What are the responsibilities and job description for the MS SQL DBA position at VDart Inc?
Job Description
Job Description
Job Title : MS SQL DBA
Location : Dallas, TX
Duration : / Term : 6 months
Job Description :
Experience Desired : 12 Years.
Minimum 12 plus years of Data Base Administration experience of which 9 plus years should have worked on SQL DBA covering Installing, configuring, and maintaining SQL Server instances and databases
About the Role Client is looking for a SQL Server DBA having related experience in Installing, configuring, and maintaining SQL Server instances and databases.
Job Responsibilities
SQL Server Database Administrator is responsible for the performance, security, and availability of an organization's SQL Server databases.
They ensure that the databases are properly designed, implemented, and maintained to meet the needs of the business.
SQL DBAs may also be responsible for monitoring and maintaining other database-related technologies, such as data replication, clustering, and high availability solutions.
Creating and managing database objects, such as tables, indexes, and constraints
Ensuring data integrity and consistency by monitoring database performance and conducting regular backups and restores.
Optimizing database performance by analyzing query execution plans and making appropriate adjustments to database configuration and schema design.
Implementing and maintaining database security measures, such as user permissions and access controls
Planning for and implementing database upgrades and migrations
Troubleshooting and resolving database issues, such as performance bottlenecks, data corruption, and connectivity problems
Collaborating with development teams to design and implement database changes that support application requirements.
Providing technical guidance and support to end users and other IT teams.
Creating and maintaining documentation related to database design, configuration, and operations.
Mandatory Skills
Minimum 12 plus years of Data Base Administration experience of which 9 plus years should have worked on SQL DBA covering Installing, configuring, and maintaining SQL Server instances and databases.
Required Education
Bachelor's degree in Computer Science, Electrical Engineering, or related field.
Required Experience
Minimum 12 plus years of Data Base Administration experience of which 9 plus years should have worked on SQL DBA covering Installing, configuring, and maintaining SQL Server instances and databases.
Extensive experience in managing large-scale SQL Server environments
Expertise in advanced performance tuning and query optimization
Proven track record of implementing and managing high availability solutions like AlwaysOn
In-depth knowledge of database security, compliance, and auditing
Experience with cloud-based database services such as AWS RDS and Azure SQ
Proficiency in SQL for creating, managing, and optimizing databases
Should have executed data integrity and availability through robust backup and recovery strategies
Should have done Monitoring and optimizing the performance of SQL Server databases
Should have Knowledge of high availability solutions like AlwaysOn, and disaster recovery planning
Should have the skill of writing and maintaining SQL scripts for various database
Should have executed setting up and managing monitoring tools and alerts to ensure database health
Familiarity with cloud-based database services such as AWS RDS and Azure SQ
Key Skills :
SQL Server DBA, Azure, HADR
