Job Description
Job Description
Title: Database Administrator
Location: Remote, EST Hours
Rate: $40/hr
Salary expectation: $80k-90k
Note: This is a contract to hire on W2. THIS IS NOT OPEN TO C2C.
**The position typically falls during business hours and requires and as needed on-call component. The person can expect to work after hours up to 5 times a month.**
Position Purpose
The DBA will be responsible for the design, development, organization, maintenance, performance, and security of client’s database environment, which includes traditional on-premises SQL databases as well as cloud-based databases.
Main Responsibilities & Duties
- Design, implement, and maintain all databases, including traditional on-premises SQL databases and cloud-based databases in Microsoft Azure.
- Ensure the security and high availability of all databases by implementing appropriate measures, such as encryption, backup, disaster recovery, and Always On availability.
- Perform database maintenance tasks, including upgrades, patching, and automation of process.
- Expert in tuning SQL queries, Index maintenance and follow best practices to optimize the database performances
- Troubleshoot database issues and provide timely resolution to minimize downtime and data loss. Support databases for 24/7 uptime.
- Collaborate with IT stakeholders to identify and implement database-related enhancements and upgrades to support business objectives.
- Develop and implement data migration and integration strategies between on-premises and cloud-based databases.
- Perform production deployments of the database, including coordinating with development teams and using automation tools to ensure a streamlined and error-free process.
- Create and maintain up-to-date documentation for the entire database ecosystem, including database schema, configurations, security, disaster recovery procedures, and performance metrics.
- Mentor and support junior team members to develop their skills and expertise in SQL database administration and cloud-based database technologies.
- Stay current with emerging trends and technologies in database management and cloud computing to ensure client’s databases remain competitive and innovative.
- Other ad hoc duties as requested by management
Professional Knowledge, Skills & Abilities
- Bachelor’s degree in IT or Computer Science or equivalent experience.
- 3+ years of experience in SQL database administration, including experience with both traditional on-premises SQL databases and cloud-based databases in Microsoft Azure.
- Expertise in SQL Server, including proficiency with database design, performance tuning, security, backup and recovery, and failover.
- Experience with ELT and data migration tools, such as Azure Data Factory and SSIS.
- Knowledge of cloud-based database services and technologies, such as Azure SQL Database, Azure Cosmos DB, and Azure Data Lake Storage.
- Familiarity with database monitoring and alerting tools, such as Azure Monitor.
- Excellent interpersonal and team-working skills, including the ability to mentor and support junior team members.
- Demonstrated ability to solve complex problems and formulate recommendations.