SQL Database Administrator (DBA) Only W2

Mokshaa Consulting LTD - Columbus, OH

Full-time

Columbus, OH

About the position

The SQL Database Administrator (DBA) position is a critical role that involves both production and development responsibilities within a hybrid work environment based in Columbus, OH. The DBA will function with a high degree of autonomy, utilizing their extensive experience and judgment to deliver database services and achieve organizational goals. This role requires participation in strategic planning for major upgrades and implementations, ensuring adherence to internal standards and guidelines. The DBA will be responsible for capacity and growth planning in alignment with business needs, ensuring that database environments are optimized for performance and availability. In this role, the DBA will install, configure, upgrade, and patch both custom-built and vendor-supplied database applications and third-party software. They will manage high-availability features such as clusters, availability groups, mirroring, and database replication. Regular database maintenance tasks will include index and statistics maintenance, space allocations, backups, and restores. The DBA will also collaborate with developers and users to address data archiving and purging needs, while developing automation scripts to streamline administrative tasks. Security and integrity of the database environments are paramount, and the DBA will define, implement, and manage security roles and permissions for all applications and database users. The focus will be on ensuring database availability and uptime, monitoring usage and performance, and taking necessary actions to improve overall performance. This includes application-specific performance tuning and testing as recommended by vendors. The DBA will consult with developers and users to define data requirements and migration procedures, partnering with server, storage, and networking teams to maintain smooth database operations. They will also interface with NOC and Help Desk teams for problem resolution and provide analysis of significant production issues. Participation in an on-call rotation is expected, along with sharing knowledge and mentoring other database administrators. Additional duties may be assigned by management as needed.

Responsibilities

• Function as a Production and a Development Database Administrator.
• Participate in strategic planning for major upgrades and implementations.
• Provide capacity and growth planning as per business needs.
• Install, configure, upgrade, and patch custom built and vendor supplied database applications.
• Manage high-availability features such as clusters, availability groups, mirroring, and database replication.
• Perform database maintenance including index/statistics maintenance, space allocations, backups, and restores.
• Develop automation scripts and processes to streamline administrative tasks.
• Ensure security and integrity of the database environments are maintained.
• Define, implement, and manage security roles and permissions for all applications and database users.
• Monitor database usage and performance, taking necessary actions to improve performance.
• Perform application-specific performance tuning and testing as needed.
• Consult with developers and users to define data requirements and migration procedures.
• Partner with Server, Storage, and Networking teams for resource needs.
• Interface with NOC and Help Desk teams for problem resolution.
• Participate in team on-call rotation and provide mentorship to other DBAs.

Requirements

• 10+ years of managing SQL Server environments with 5-7 years' experience in SQL Server 2014 or later in an administrative role.
• High-level proficiency in SQL, T-SQL, and PowerShell.
• 3+ years of experience building, deploying, and maintaining ETL packages using SSIS.
• Experience installing, configuring, and upgrading database software including HADR configurations.
• 3-5 years' experience creating/updating/optimizing/troubleshooting stored procedures, functions, tables, views, triggers, indexes, and constraints.
• Experience with database object migrations across multiple environments.
• Experience in troubleshooting and resolving job failures, performance issues, blocking/deadlocking issues, connectivity, and security issues.
• Proficient in optimizing database workloads using Profiler/Extended Events/DMVs or other monitoring tools.
• Good working knowledge of Windows Server operating systems (2012/2016/2019).
• Strong knowledge of backups, restores, and recovery models.
• Solid understanding of various Amazon Web Services, especially AWS RDS, EC2, and S3.
• Familiarity with other SQL/NoSQL databases such as Oracle, MySQL, PostgreSQL, MongoDB is a plus.
• Experience with enterprise information security and database security management.
• Experience with source control and change control processes and tools.
• Ability to work unsupervised and prioritize tasks effectively.
• Excellent written and verbal communication skills.

Nice-to-haves

• Familiarity with other SQL/NoSQL databases such as Oracle, MySQL, PostgreSQL, MongoDB is a plus.
• Experience with Solarwinds DPA is preferable.