What are the responsibilities and job description for the Database Administrator (Senior Level) position at Omm IT Solutions?
Job Description
Database Administrator (DBA) Resources are responsible for the administration and maintenance of the organization's database platforms. They use established database standards, procedures, and processes to ensure that systems are healthy and functional. They build and execute scripts to modify data in organizational databases. A DBA develops and maintains highly available databases, including physical dictionaries and data models, and implements changes and performance enhancements. DBA Resources may access Federal Tax Information. Background checks required, per IRS Publication 1075, apply.
Requirements
Basic Qualifications (Mandatory) :
- Associate's degree in computer science or related field, or equivalent training and experience in IT.
- 7 years of experience in enterprise RDBMS Database administration with large-scale, mission-critical applications (Microsoft SQL Server 2012 ).
- Formal education in Computer Science, Information Systems, Engineering, or a related field can be substituted for the following years of experience :
- Bachelor's Degree : 1 year
- Master's Degree : 2 years
- Experience with Database Server Performance and Optimization tools.
- Experience managing database backup, restore and data archiving tasks.
- Experience with Microsoft SQL Server security best practices.
- Advanced knowledge of AlwaysOn, Transactional Replication, Clustering and T-SQL.
- Experience with implementing database upgrades.
- Experience with Database PAAS solutions in a cloud solution.
- Experience with CI CD process and setup from database end.
- Scripting knowledge for automating day to day tasks (Shell script, Power shell).
- Knowledge on Azure Data Factory.
- Knowledge on ETL data warehouse architecture.
- Working experience on CDC tools & replication.
- Installs, Patches, upgrades, and maintains the system health
Preferred Qualifications (Desired) :
