Note: The job is a remote job and is open to candidates in USA. CloudIQ Technologies provides cloud management, infrastructure and application migration, application modernization, and data analytics engineering services across Azure, AWS, and Kubernetes. The company is seeking a Mid-Level SQL Server Database Administrator / Database Engineer to manage, optimize, and support Microsoft SQL Server databases through administration, performance tuning, T-SQL development, high availability, disaster recovery, and production support.
Responsibilities
- Design and maintain SQL Server databases, tables, indexes, and other objects
- Develop, review, and optimize T-SQL queries, stored procedures, functions, and views
- Collaborate with developers to ensure efficient schema design and data access patterns
- Install, configure, and maintain Microsoft SQL Server instances
- Manage database security, users, roles, and permissions following least-privilege principles
- Implement, monitor, and test backup and recovery strategies
- Perform regular database maintenance (index maintenance, statistics updates, integrity checks)
- Monitor database performance and resolve bottlenecks related to queries, indexes, blocking, and resource usage
- Analyze execution plans and make recommendations for tuning
- Troubleshoot database-related incidents and provide root cause analysis
- Assist in implementing and supporting HA/DR solutions (e.g., Always On Availability Groups, Log Shipping, Clustering)
- Help ensure databases meet security, compliance, and audit requirements
- Participate in planning and testing of disaster recovery scenarios
- Use monitoring tools to proactively identify and address issues
- Provide production support, including participation in an on-call rotation as needed
- Create and maintain documentation for configurations, processes, and standards
- Work with cross-functional teams (Developers, DevOps, Infrastructure, BI) to support projects and deployments
- Contribute to automation efforts (scripts, PowerShell, deployment processes) to reduce manual work
- Help define and enforce database best practices and coding standards
Skills
- Bachelor's degree in computer science, Information Technology, or equivalent practical experience
- Approximately 3–5 years of hands-on experience with Microsoft SQL Server in a production environment
- Strong skills in:
- T-SQL and query optimization
- Database design, indexing, and normalization
- Backup/restore and core HA/DR concepts
- Experience with SQL Server tools (SSMS, Extended Events/Profiler, Performance Monitor, etc.)
- Demonstrated ability to troubleshoot and resolve database performance and availability issues
- Experience with cloud database platforms (e.g., Azure SQL, Azure Managed Instance, AWS RDS for SQL Server)
- Exposure to SSIS, SSRS, or SSAS
- Scripting/automation experience (e.g., PowerShell, Python, or similar)
- Familiarity with version control and database deployment via CI/CD pipelines
- Microsoft SQL Server or Azure database-related certifications are a plus
- Strong analytical and problem-solving skills
- Ability to work independently while collaborating effectively with a team and stake holders and leaders
- Clear verbal and written communication
- Comfortable working in a fast-paced environment and handling multiple priorities
Company Overview
Company H1B Sponsorship