SQL Database Administrator- Columbus, OH

Position- SQL Database Administrator

Location- Columbus, OH

Essential Activities and Responsibilities :

• Function as a Production and a Development Database Administrator.
• s a Database Administrator, performs specialized technical job functions with limited instruction while relying on experience and broad judgement to deliver services and accomplish goals. Participates in strategic planning for major upgrades and implementations while following the internal standards and guidelines. Provides capacity and growth planning as per the business needs.
• Installs, configures, upgrades and patches custom built, as well as vendor supplied database, applications and / or third-party software. Installs and manages high-availability features such as clusters, availability groups, mirroring and database replication.
• Performs database maintenance such as index / statistics maintenance, space allocations, backups, restores and works with developers and users about data archiving / purging. Develops automation scripts and processes to streamline administrative tasks.
• dheres to standard protocols in ensuring that security and integrity of the database environments are maintained. Defines, implements, and manages security roles and permissions for all applications, modules and database users.
• Focuses on Database Availability and Uptime. Monitors database usage and performance and takes necessary actions regarding indexes, SQL statements, space allocations and server / database configurations to improve overall performance. Performs application-specific performance tuning and testing as needed and as recommended by vendor for their specific applications.
• Consults with developers and users to define data requirements, data load needs, database standards and migration procedures. Partners with Server, Storage and Networking teams for various resource needs and to keep Database Systems functioning smoothly. Additionally, Interfaces with NOC and Help Desk teams for problem / failure resolution, and to provide information and analysis of significant production issues.
• Participates in team on-call rotation; shares knowledge and provides mentorship and support to other database administrators. Carries out other duties as assigned by management.

Knowledge, Skills, & Abilities :