SQL Server DBA
10+ years of experience needed
Must have active SQL DBA certification
Hybrid Role
Must be local to Ohio
Only H1, OPT EADs, GC-EAD and USC.
Position: Product Specialist 5 / PS 5 (SQL Server DBA )
Location: Columbus, OH
Client: State of Ohio
Agency: DCY
Interview Type: video interview
Position ID: 762673
SQL Server Database Administrator -Job Description
The Department of Children and Youth (DCY),Office of Information Services (OIS), is seeking an experienced database administrator who will drive high-caliber database design, solution delivery, and support in a fast-paced and collaborative environment. The successful candidate must be an influential technical leader with deep database expertise and a collaborative style that promotes a culture of innovation and well managed excellence. We are seeking an experienced SQL Server DBA managing the MS SQL Server environments including the DB VM servers.
The candidate will be working with other database administrators across different agencies that manage several database platforms, including (but not limited to) Azure Cloud platform, Oracle Databases.
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 DBAITM1 to ensure that team goals and metrics are met.
DCY is working with a vendor to migrate a few SQL based applications into the Azure Cloud environment and we need this DBA to take the lead to learn the applications in the current system to be able to manage them in the Cloud environment.
- 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.
- 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.
- Plans and implements capacity and resource expansion to ensure scalability of databases.
- Implements effective risk management controls and owns adherence to all compliance related items (exceptions, waivers, risks, technical compliance, and access control)
- Leads incident resolution efforts and engages appropriate resources to complete corrective actions as quickly as possible.
- Conducts research and provides recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Virtualized Infrastructure running various Unix, Linux, and AIX operating systems.
- Altering storage structures to meet the evolving needs of the Organization.
- Regularly updating the database security protocols, patching.
- Provides leadership and work guidance to less experienced personnel.
- . Willalso work with project management to support and ensure timely and effectiveclient communications about deployments and upgrades.
Skills | Required / Desired | Your Amount of Experience in years/month |
4 years of college | Highly desired | |
Maintaining SQL database within the Azure Cloud | Highly desired | |
Must be very dependable and experienced SQL DBA to work with SQL apps within the Cloud environment | Required | |
Experience as SQL Server DBA | Required | 9 |
SQL Server DBA certification is preferred | Highly desired |
Warm Regards,
Piyush Negi
Technical Recruiter
Direct: (614) 888 0700 Ext 208
LinkedIn: https://www.linkedin.com/in/piyush-negi-6b75b9130/
Fax: 614-573-7255
Flairsoft Limited – Address: 7720 Rivers Edge Dr. Suite 200 Columbus, OH 43235
CMMi and ISO 9001 Certified
for more information on our company’s capability and experience please visit http://flairsoft.net/capability-statement/
We Deliver. You Succeed.
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer