Automation/ SQL Database Administrator

Company: ClearBridge Technology Group
Location: Charlotte
Posted on: November 23, 2020

Job Description:

Our client, located in Charlotte, NC, is in need of a AutomationSQL Database Administrator for a full-time position. The Administrator will be spending 75 of time working on automation efforts, including using a tool that is Oracle APEX frontend, Ansible backend. As such, the Admin must have a development background, representing the SQL team re what tasks need to be automated, and associated best practices. The Admin will be working alongside shared Ansible and APEX resources to review playbooks, verify automation works, and get hands-on with edits where needed. As more automation is completed, this position will shift focus into more of a traditional production SQL DBA role. Duties Included Actively and consistently supports all efforts to simplify and enhance the customer experience. Administer automation platform and assist in code development via Ansible and Oracle Application Express tool set. Support internal SSRS and Power Bi report development Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data. Designs and maintains access and security administration. Designs, implements and maintains backup and recovery strategies on Database Management Systems. Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data. Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Knowledge of Always-On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues. Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth. Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation. Gathers business requirements and designs, implements multiple projects along with the production support. Creates standard operational procedures and templates. Acts as mentor for Database Administrators and Associate Database Administrators. Performs research and provides plans to remediate complex business problems. Assists the development teams to improve database design and procedures on TSQL best practices etc. Required Skills 5 yearsrsquo experience working with SQL Databases Must have T-SQL experience Must have experience working in enterprise-level environments Must have experience supporting production and development databases 3 years' developmentautomation experience Ansible-specific development and playbook experience highly preferred PowerShell is fine as well Must be able to assess andor edit playbooks, not just run Strong communication and collaboration skills

Keywords: ClearBridge Technology Group, Charlotte , Automation/ SQL Database Administrator, Other , Charlotte, North Carolina