Database Administrator - III

AmNet Services, Inc.; Highlands Ranch (CO); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading technology company in Highlands Ranch, Colorado is seeking an experienced Microsoft SQL Server DBA. The role involves planning, coordinating, and administering database systems while providing expertise to the software development team. Candidates should have 5+ years in database administration, a Bachelor of Science degree, and experience with Microsoft SQL Server 2008/2014. US Citizenship is required, and prior Verizon experience is preferred. Excellent project management and communication skills are essential.

Qualifications

• 5+ years in a database administration and/or application development role.
• US Citizenship required.
• Prior Verizon experience preferred.

Responsibilities

• Plan, coordinate, and administer database systems.
• Provide database expertise in design and maintenance.
• Develop ETL processes and tools for data migration.
• Collaborate with vendors and internal management for implementation.

Skills

Transact-SQL

Replication

DTS/SSIS packages

SQL Agent jobs

SQL Reporting Services

ActiveX scripting

Project management skills

Written and verbal communication skills

Education

Bachelor of Science degree

Tools

Visual Studio .NET

Microsoft Office Suite (Word, Access, Excel)

Windows Operating Systems

Windows Server Applications (IIS, Cluster Administrator, Terminal Services)

Crystal Reports

WinZip

FTP

Job description

America Networks is a leading sensor and networking solutions partner for companies in any Industrial, Manufacturing, and Waste management space. We design and manufacture sensors for storage tanks, water metering, energy metering, gas monitoring, and asset management. Our founders are hardcore telecommunications engineers with combined 200 + years of experience in designing, optimizing and performance engineering; for several mid – large wireless carriers internationally - that saw a need to provide low power, cost efficient sensors to collect data, create alerts, and predict needed actions. We have combined these sensors with low power, wide area (LPWA) networking technologies to provide clients various options to decrease re-occurring costs associated with operating an IoT network of sensors and connected devices. We specialize in design, deployment, optimization, and support of these Networks. Whether an off-the-shelf or custom solution is needed, we’ll create a solution and push the data on the best cloud platform to fit your needs, including your own.

Job Description

Microsoft SQL Server DBA Primary responsibility is the ongoing support and administration of database software systems - Plan, coordinate, and administer database systems, including base definition, structure, documentation, long range requirements, operational guidelines and protection - Provide database expertise to the software development team in the design, development and maintenance of the core database - Developing the ETL (Extract, Transform, Load) processes and tools needed to migrate this data - Develop cross validation rules to ensure mapping accuracy - Collaborate with vendors and internal management to help drive implementation of data migration with the mapping of data used in custom web metric reporting tools and dashboards - 5+ years in a database administration and/or application development role - Bachelor of Science degree or equivalent education and work experience is required - Skills required in areas of Microsoft SQL Server 2008/2014 such as Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and ActiveX scripting - Other software the applicant should be familiar with include, Visual Studio .NET, Microsoft Office Suite (Word, Access, and Excel), Windows Operating Systems, Windows Server Applications (IIS, Cluster Administrator, Terminal Services), Miscellaneous Support Tools (Crystal Reports, WinZip, FTP) - Excellent project management skills and written and verbal communication skills - Prior Verizon experience preferred - US Citizenship required

Responsibilities

• Plan, coordinate, and administer database systems, including base definition, structure, documentation, long range requirements, operational guidelines and protection.
• Provide database expertise to the software development team in the design, development and maintenance of the core database.
• Develop the ETL (Extract, Transform, Load) processes and tools needed to migrate this data.
• Develop cross validation rules to ensure mapping accuracy.
• Collaborate with vendors and internal management to help drive implementation of data migration with the mapping of data used in custom web metric reporting tools and dashboards.

Qualifications

• 5+ years in a database administration and/or application development role.
• Bachelor of Science degree or equivalent education and work experience is required.
• Skills required in areas of Microsoft SQL Server 2008/2014 such as Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and ActiveX scripting.
• Other software the applicant should be familiar with include, Visual Studio .NET, Microsoft Office Suite (Word, Access, and Excel), Windows Operating Systems, Windows Server Applications (IIS, Cluster Administrator, Terminal Services), Miscellaneous Support Tools (Crystal Reports, WinZip, FTP).
• Excellent project management skills and written and verbal communication skills.
• Prior Verizon experience preferred.
• US Citizenship required.