Database Administrator
- Jacksonville, FL Atlanta, GA
- Permanent
- Full-time
- Designs and architect’s database solutions.
- Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance, and cost.
- Performs data analysis to provide management with timely and accurate information and predict future requirements.
- Ensures service level agreements are met for internal and external clients.
- Provide strategic engineering solutions to drive technology improvements
- Take ownership of projects to ensure successful implementation including Tech-Stack upgrade efforts
- Foster relationship and act as a technical liaison between the DBA Team and the Lines of Business
- Monitors database performance, availability, and capacity.
- Participates in continuous business process redesign to improve internal operations.
- Performs backup and recovery on Database Management Systems, configures database parameters and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements
- Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost
- Ensures service level agreements are met for internal and external clients
- Provides status reports that detail issues for escalation to management
- Performs configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systems
- Perform troubleshoot Service broker queues, messages flow, and stuck messages flow.
- Perform BizTalk SQL server support and SME to support messages SLA.
- Performs data analysis to provide management with timely and accurate information and predict future requirements
- Develops, implements and tests database backup and recovery policies and procedures.
- Creates and maintains documentation for database policies, procedures, and processes.
- Performs/schedules routine maintenance on databases to keep them running at peak performance.
- Monitors database performance, availability, and capacity
- Review database storage utilization to ensure proper whitespace allocations
- Review and develop trend analysis for incident remediation and prevention
- Participates in continuous business process redesign to improve internal operations
- Interfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational support
- Troubleshoots issues and recommends solutions
- Research and evaluate new RDBMS for possible implementation
- Performs other duties as required
- Bachelor’s degree in computer science, Information Systems or the equivalent combination of education, training, or work experience
- Requires nine (9) or more years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment.
- Required to participate in a 24x7 on-call rotation
- Expert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019 [SQL 2022 is a plus])
- Expert level knowledge SQL performance and tuning
- Expert level knowledge of Microsoft GEO-Clustering and Always-On Availability Groups in local and geographically dispersed data centers
- Extensive knowledge of task automation
- Strong database design and analysis skills
- Expert level Knowledge of backup and recovery operations for database management systems
- Expert level Knowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLS
- Expert level Knowledge of OS, storage, and network layers for troubleshooting purposes
- Expert level Knowledge of relational database concepts and terminology
- Ability to monitor and tune databases and instances
- Ability to maintain and monitor availability, security, and integrity of databases
- Ability to focus on production and customer needs and deliverables
- Ability to adapt to the use of new software tools as they are acquired or adopted within IT
- Strong written and verbal communication skills
- Must be self-motivated, a team player, and have a strong track record in customer satisfaction
- Demonstrated experience with successful system and project implementations
- Nice to have Service Broker, and Biz Talk SQL support.
- Nice to have experience to interact with Mainframe flat files ingestion architecture.
- Nice to have experience for DB2 to SQL server migration.
- Knowledge of PowerShell Scripting and Automation
- Knowledge of AWS – RDS SQL
- Knowledge of Microsoft Azure RDBMS
- Knowledge of Cloud SaaS RDBMS
- Knowledge of OLA Hallengren maintenance plans
- Experience with scripting languages
- Strong problem-solving skills
- Ability to work independently and in a team environment with minimal supervision
- Ability to learn and apply new skills in a constantly changing technical environment