SQL DBA - Inabia Software & Consulting Inc.

Title: SQL DBA
Duration: 3 Month Contract
Location: Dallas, TX(Onsite – 4 days from office and one day remote)
Rate: $40-$43 per hour

Job Description :   
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 14 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 SQL

Powered by JazzHR