Sr. SQL Server DBA

3 days ago

Houston, TX, United States MHK TECH INC Full time

We are seeking a skilled and experienced SQL Server Database Administrator (DBA) to lead and execute the on-premises upgrade initiatives for our client's SQL Server databases. You will be responsible for planning, implementing, and managing the upgrade process while ensuring the stability, security, and performance of our database environment.

**Responsibilities:**

1. **Upgrade Planning:**
- Collaborate with stakeholders to define upgrade goals, scope, and objectives.
- Assess the current database environment and applications to determine compatibility and potential issues with the new SQL Server version.
- Develop a detailed upgrade plan outlining tasks, timelines, resource requirements, and risk mitigation strategies.

2. **Database Pre-Upgrade Activities:**
- Backup and secure existing databases and related objects to ensure data integrity.
- Review and optimize database schema, indexes, and queries to enhance performance.
- Identify and address security vulnerabilities and compliance concerns.

3. **Upgrade Execution:**
- Lead the execution of the upgrade process, ensuring minimal downtime and impact to business operations.
- Monitor the upgrade process and address any issues or errors that arise during the upgrade.
- Perform necessary compatibility tests and resolve any application-related issues.

4. **Post-Upgrade Validation:**
- Conduct thorough testing of upgraded databases to verify functionality, data integrity, and performance.
- Collaborate with development teams to validate application compatibility and resolve any post-upgrade issues.
- Document the upgrade process, changes made, and lessons learned for future reference.

5. **Performance Tuning and Optimization:**
- Monitor database performance post-upgrade and identify opportunities for optimization.
- Fine-tune query performance, indexes, and configurations to ensure optimal performance.

6. **Security and Compliance:**
- Implement security best practices for the upgraded databases, including user access, roles, and permissions.
- Ensure compliance with relevant data protection regulations and internal security policies.

7. **Documentation and Reporting:**
- Maintain comprehensive documentation related to database upgrades, configurations, and changes.
- Provide regular status reports to management, highlighting progress, challenges, and recommended solutions.

**Qualifications:**

- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a SQL Server Database Administrator, with a focus on database upgrades and migrations.
- Strong knowledge of SQL Server versions and editions, with expertise in planning and executing upgrades.
- Proficiency in database performance tuning, query optimization, and troubleshooting.
- Familiarity with security best practices and compliance requirements for database systems.
- Excellent problem-solving skills and the ability to work under pressure to resolve critical issues.
- Strong communication skills to collaborate with cross-functional teams and stakeholders.
- Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.
- Experience with scripting languages (e.g., PowerShell) for automation is desirable.
- Prior experience in on-premises to cloud migration is a Must.

  • Senior SQL DBA with AWS

    3 days ago

    Houston, TX, United States r2 Technologies, Inc. Full time

    Role: Senior SQL DBA with AWS ( Architect Level ) Duration: 12 months with extension Location: Houston, TX Interview: Video Hybrid onsite - 2 days a week AWS experience is a must. AWS certs are a huge plus The successful candidate will perform related activities for the development and sustainment for SQL Server and AWS Data Development, ensuring its...

  • Senior SQL DBA with AWS

    2 weeks ago

    Houston, TX, United States r2 Technologies, Inc. Full time

    Role: Senior SQL DBA with AWS ( Architect Level ) Duration: 12 months with extension Location: Houston, TX Interview: Video Hybrid onsite - 2 days a week AWS experience is a must. AWS certs are a huge plus The successful candidate will perform related activities for the development and sustainment for SQL Server and AWS Data Development, ensuring its...

  • Senior SQL DBA with AWS

    6 days ago

    Houston, TX, United States r2 Technologies, Inc. Full time

    Role: Senior SQL DBA with AWS ( Architect Level ) Duration: 12 months with extension Location: Houston, TX Interview: Video Hybrid onsite - 2 days a week AWS experience is a must. AWS certs are a huge plus The successful candidate will perform related activities for the development and sustainment for SQL Server and AWS Data Development, ensuring its...

  • .Net Developer

    2 weeks ago

    Houston, TX, United States Omni Inclusive Full time

    Description - 8+ years of solid development experience of .NET framework, C#, ASP.Net, Web Services, WCF, JQuery and Web API. - Good experience of Oracle, SQL Server and Stored procedures and should have knowledge on how to debug an Oracle PackageStored Procedure - Good experience using GIT/TFS and working with Agile methodologies. - Good experience in...

  • .Net Developer

    1 week ago

    Houston, TX, United States Omni Inclusive Full time

    Description - 8+ years of solid development experience of .NET framework, C#, ASP.Net, Web Services, WCF, JQuery and Web API. - Good experience of Oracle, SQL Server and Stored procedures and should have knowledge on how to debug an Oracle PackageStored Procedure - Good experience using GIT/TFS and working with Agile methodologies. - Good experience in...

  • .Net Developer

    2 days ago

    Houston, TX, United States Omni Inclusive Full time

    Description - 8+ years of solid development experience of .NET framework, C#, ASP.Net, Web Services, WCF, JQuery and Web API. - Good experience of Oracle, SQL Server and Stored procedures and should have knowledge on how to debug an Oracle PackageStored Procedure - Good experience using GIT/TFS and working with Agile methodologies. - Good experience in...

  • .Net Developer

    2 weeks ago

    Houston, TX, United States Omni Inclusive Full time

    Description - 8+ years of solid development experience of .NET framework, C#, ASP.Net, Web Services, WCF, JQuery and Web API. - Good experience of Oracle, SQL Server and Stored procedures and should have knowledge on how to debug an Oracle PackageStored Procedure - Good experience using GIT/TFS and working with Agile methodologies. - Good experience in...

  • .Net Developer

    4 days ago

    Houston, TX, United States Omni Inclusive Full time

    Description - 8+ years of solid development experience of .NET framework, C#, ASP.Net, Web Services, WCF, JQuery and Web API. - Good experience of Oracle, SQL Server and Stored procedures and should have knowledge on how to debug an Oracle PackageStored Procedure - Good experience using GIT/TFS and working with Agile methodologies. - Good experience in...

  • Oracle Apps DBA

    1 week ago

    Houston, TX, United States The Dignify Solutions LLC Full time

    Manage and support multiple Development, Test and Production environments on Oracle applications. Perform clones, patching, and code migrations as necessary to support business requirements. Provide and maintain comprehensive documentation on database systems, configurations, processes and standards. Support 24/7 applications with strong understanding of...

  • Sr. BI Developer

    6 days ago

    Houston, TX, United States Nava Software Solutions Full time

    NAVA Software solutions is looking for a Sr. BI Developer Details: Sr. Business Intelligence Developer (BI Developer) Location: Remote Duration: Full time / Direct Hire Position Summary: The BI Developer is responsible for supporting the business areas and clients by developing business intelligence solutions leveraging the Microsoft technology platform...