Note : Remote but candidate must local to Ohio.
The SQL Server DBA will be responsible for managing Microsoft SQL Server Database environments including on the SQL Server databases virtual machine (VM) servers. They will ensure best practices in database planning design configuration performance and capacity planning and growth ensuring our SQL databases offer the highest reliability and performance possible. They will work with the DBA ITM1 to ensure that team goals and metrics are met. Will also work with project management to support and ensure timely and effective client communications about deployments and upgrades.
- Should be able to provide DBA support for distributed servers in a multidatacenter environment.
- Virtualized Infrastructure running various Unix Linux and AIX operating systems.
- Support DevOps tools (Ansible Jenkins Nexis Mavin Bitbucket Kony Mobile Nginx etc.)
- Monitor daily activities and performance of complex SQL environment analyzes technical problems recommend adjustments creates and implements approved solutions using established tools and techniques.
- Provide technical assistance to the application development area and coworkers about SQL design and programming.
- Configures SQL services (e.g. security JDBC clusters). Plans installs and coordinates SQL Server releases migrations upgrades and maintenance. Build new environments as needed to support applications.
- Coordinating with the teams of network IIS administrators and storage groups for SQL serverbased configurations.
- Develop technical documents project plans and tasks interact with customers for proposed solutions.
- Provide nonproduction and production support for deploying code and assist in trouble shooting and resolving application issues.
- Any other tasks assigned by the management team based on project/application needs.
- Provide technical Tier III support develops project plans with project manager or recommends approach through defining tasks.
- Leading meetings relating to design implementation operation and ongoing maintenance of databases systems.
- Designs/plans of cluster nodes hardware selection and recommendations configures/sets up cluster nodes setsup interconnects and configures cluster aware storage; installs cluster and database management system (DBMS) software on all nodes.
- Monitoring load balance and tunes cluster parameters for high performance configuring standby servers.
- Configuring and implements log shipping configures and implements replication etc.
- Provide technical leadership that fosters database innovation and champions automation.
- Support strategic planning for database architecture resource management and capacity planning and growth.
- Ensures best practices in database planning design configuration performance and resilience.
- Evaluate and proposes design and process improvements to achieve performance and cost optimization.
- Identify inefficiencies in current database designs and oversees the implementation of improved solutions.
4year college degree or equivalent technical study Required 4
Experience as SQL Server DBA Required 9
Seeking an experienced SQL Server DBA with managing the MS SQL Server environments including the DB VM servers Required
SQL Server DBA certification is Desired Highly desired