Title : Product Specialist 5 / PS 5 (SQL Server DBA)
Location : Columbus, OH
Duration : 7 Months
REMOTE for Now
Job Description :
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.
- Should be able to provide DBA support for distributed servers in a multi-datacenter environment.
- 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 co-workers 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 server-based configurations.
- Develop technical documents, project plans and tasks, interact with customers for proposed solutions.
- Provide non-production and production support for deploying code and assist in trouble shooting and resolving application issues.
- Support DevOps tools (Ansible, Jenkins, Nexis, Mavin, Bitbucket, Kony Mobile, Nginx etc.)
- 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, sets-up interconnects, and configures cluster- aware storage;
installs cluster and database management system (DBMS) software on all nodes.
23 hours ago