Mokshaa Consulting LTD - Columbus, OH
posted 2 months ago
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.