Database Administrator

Come work for a premier environmental engineering firm that specializes in the planning, design, and construction of water and wastewater facilities. As a member of our IT Applications team, the SQL Server DBA will be responsible for designing and maintaining SQL Server infrastructure adhering to corporate requirements and standards. Responsibilities include all aspects of the database administration and cross-functional teams that align and lift strategic initiatives. The SQL Server DBA will deliver quality recommendations, process-changing ideas, and design that drive new and significant improvement within the IT department, Applications team, business, and applications. The DBA is a hands-on technical role with opportunity to grow, learn, experience technical diversity on daily basis, and a member of a driven Applications team. This position will report to the IT Apps-Dev Lead.
Responsibilities

• Oversee the maintenance, configuration, and implementation of everything that has to do with databases. This includes the replication, backup, storage, access and partitioning of databases
• Consulting with business owners and application architects on all strategic deployments, generating architectural design documents, generating SSIS packages and SSRS reports and BI platform, and presenting design concepts and solutions to internal customers
• Installations, configurations, troubleshooting, and maintenance of database systems
• Manage the design and implementation of security and data access methods to ensure services are properly controlled, monitored and audited
• Develop and implement maintenance and administration procedures for database systems including the usage of metrics to ensure optimal performance
• Work with 3rd party companies and consultants as needed to support commercial applications to be install on Carollo’s database infrastructure
• Author, document and maintain scripts to perform various aspects of data management and system administration
• Proactively monitor database system status to determine early warning signs of issues
• Performs other duties as assigned

Qualifications

• Bachelor’s degree or applicable work experience in Computer Science, Information Systems, or Decision Sciences
• Five (5) or more years of experience in database administration and support
• Database design, logical/physical data modeling/design, data security and SSIS or similar ETL tools
• Must have strong knowledge of data relationships, normalization and summarization
• Implementing or maintaining stored procedures, views and triggers
• SQL tuning, Data conversion / Migration, Supporting Development, Test and Production System
• Database maintenance, Database backup and recovery
• Setup and constantly improve maintenance, operational and monitoring processes
• Export/Import Replication, Maintaining back up jobs, Creating Linked Server Objects
• Experience in Database Mirroring, log shipping and DR procedures
• Experience in SQL transactional Replication
• Server virtualization and SAN storage strategies experience
• Supporting MS SQL databases in Microsoft clustered environments

Preferred Qualifications

• MCDBA (Microsoft Certified Database Administrator) certification
• Ten (10) or more years of experience in database administration and support
• MS SQL Server experiences
• SQL Availability groups is a plus
• Experience supporting large systems (i.e. Intranet, ERP, CRM)

Flexible work from home options available.