Senior Cloud Database Administrator

We’re HCSS. We’re a software company based in Sugar Land, TX and we provide innovative solutions for the construction industry that help streamline their operations. Our mission at HCSS is to help customers dramatically improve their business through our innovative, high-quality software and exceptionally helpful service while providing a great life for our employees. With this mission at the forefront of everything we do, we’re recognized as a pioneer and leader in our market and nominated the “Best Companies to Work for in Texas” 15 years in a row. 

WHO WE NEED: 

We’re currently looking for a SQL Server Cloud Database Administrator with 8+ years of experience to join our high-performing Development team and provide our customers with quality service. If you're a fit, the following things should sound like you: 

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
• Proven experience as a SQL Server database administrator, preferably in a cloud environment.
• In-depth knowledge of relational database management systems (SQL Server).
• In-depth knowledge of performance tuning and optimization in SQL Server.
• Hands-on experience with cloud platforms such as Azure & AWS
• Experience with Microsoft Azure is a plus.
• Proficiency in database administration tools and utilities for Azure SQL Database.
• Strong understanding of database security and troubleshooting techniques.
• Excellent communication skills and ability to work effectively in a collaborative team environment

Preferred Skills:

• Knowledge of other RDBMS systems (e.g. PostgreSQL, MySQL).
• Knowledge of NoSQL databases (e.g., MongoDB, Cassandra).
• Certification in cloud platforms (Specialty, Microsoft Certified: Azure Database Administrator Associate).
• Knowledge of big data technologies (e.g., Hadoop, Spark) and data warehousing concepts.
• Understanding of infrastructure automation tools (e.g., Bicep, Terraform) and configuration management systems.

WHAT YOU’LL DO:

1. Database Design and Implementation

• Design and implement database schemas, tables, indexes, and views to meet application requirements.
• Configure elastic pools, databases, and replicas for optimal performance and scalability.

2. Database Maintenance and Monitoring

• Monitor elastic pool and individual database performance, resource utilization, and capacity planning.
• Troubleshoot and resolve database-related issues, including performance bottlenecks and data corruption.

3. High Availability and Disaster Recovery

• Configure and manage database replication, failover, and disaster recovery solutions.
• Develop and test contingency plans for handling database outages and system failures.

4. Automation and Scripting:

• Support and maintain provisioning, configuring, and managing database and elastic pool resources.
• Leverage Infrastructure as Code (IaC) frameworks for deploying and scaling database infrastructure.
• Streamline repetitive tasks and workflows through scripting and automation.

5. Collaboration and Documentation:

• Collaborate with cross-functional teams to understand application requirements and database dependencies.
• Provide technical guidance and support to developers, QA engineers, and system administrators.