What are the responsibilities and job description for the Database Administrator position at Confidential?
The Database Administrator is responsible for the design, deployment, and management of Microsoft SQL databases across multiple geographically separated data centers. The database administrator is responsible for the maintenance of databases including production support, security and auditing, performance tuning, backup and recovery, data replication, DR testing, standards, policies and procedure enforcement, and documentation.
Responsibilities
- Provide database management and support for environments including setup, configuration, deployment, monitoring, alerting, auditing and security
- Responsible for the development and implementation of preventative maintenance routines to ensure availability and performance of database files and their related management systems including tuning recommendations, capacity planning, database security and data integrity
- Ensure proper security of all databases and their respective database management systems within the company including maintaining the audit security roles, auditing security and account management functions.
- Management of software versions, installations, upgrades and patch installations across all production and non-production environments.
- Provide ad hoc data analysis in support of the company’s data analytics programs during all stages of development.
- Designs and executes automated processes to collect and prepare complex or large volumes of data for analysis, including data extraction from multiple data sources, cleansing, transformation, profiling, and data quality monitoring
- Develop, maintain, and troubleshoot complex scripts using industry standard tools.
Position Requirements
Formal Education & Certification
- Bachelor’s Degree in Information Systems or a related field
- Minimum 8 years’ work experience in managing SQL databases.
Knowledge
- Advanced knowledge of MS SQL database administration as demonstrated by no less than 8 years’ experience working as a SQL database administrator.
- Working knowledge of database design for large relational databases
- Working knowledge of industry-standard data warehousing practices
- Good understanding of MS SQL database security practices and procedures
- Knowledge of data quality, data management and data testing strategies and practices
- Preferred experience supporting AI, machine learning, or other statistical modeling techniques
- Preferred experience supporting data sources containing PII data and associated regulatory and information security requirements
Abilities
- Ability to demonstrate proficiency with tuning MS SQL databases for performance, reliability and availability
- Ability to demonstrate proficiency with MS SQL backup, restore, and failover strategies
- Ability to implement automation to reduce administrative tasks through the use of jobs, scripts and other techniques.
Working Conditions
- Occasional evening and weekend work to meet deadlines
- On-call availability for emergency issues
Job Type: Full-time
Pay: $85,000.00 - $150,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- Monday to Friday
Supplemental Pay:
- Bonus pay
Education:
- Bachelor's (Required)
Experience:
- managing SQL databases: 8 years (Required)
Work Location: One location
