RDS SQL Server Database Developer & Administrator

Ishvara Tech Consulting Pvt Ltd; Delhi Charter Township (MI); On-site; USD 90,000 - 140,000; Full time

Job summary

Ishvara Tech Consulting Pvt Ltd is seeking a highly skilled SQL Server Database Developer & Administrator to manage large-scale AWS RDS SQL Server environments. The role focuses on performance tuning, partitioning, indexing, and efficient data retrieval.

You will collaborate with cross-functional teams to design scalable schemas, implement security measures, and ensure high availability through robust backup and disaster recovery plans.

Qualifications

• Experience with large-scale databases and AWS RDS SQL Server.
• Strong performance tuning, partitioning, indexing, and data retrieval.
• Bachelor's or master's degree in CS or related field.

Responsibilities

• Manage AWS RDS SQL Server instances for high availability.
• Optimize queries, indexes, and stored procedures.
• Implement table partitioning and sharding strategies.
• Design and manage clustered, non-clustered, full-text, and columnstore indexes.
• Analyze and refactor SQL queries for best execution plans.
• Use caching, materialized views, and hints to speed data retrieval.
• Design scalable database schemas for large-scale processing.
• Develop efficient pagination techniques.
• Implement encryption, masking, auditing for security and compliance.
• Develop backup strategies and disaster recovery.
• Monitor via AWS CloudWatch, SQL Profiler, Perf Monitor, Extended Events.
• Collaborate with developers, data engineers, and DevOps.

Education

Master's/Bachelor's degree in Computer Science or related field

Tools

AWS RDS SQL Server

SQL Server 2016/2019/2022

SQL Profiler

Extended Events

DMV Queries

SSIS

PowerShell

T-SQL

BCP

Linked Servers

Always On

Log Shipping

Performance Monitor

Columnstore Indexing

Query Store

Partitioning

Job description

Summary

We are seeking a highly skilled SQL Server Database Developer & Administrator with expertise in handling large-scale databases. The ideal candidate should have extensive experience in database optimization, partitioning, indexing, query performance tuning, and efficient data retrieval. The role requires deep knowledge of AWS RDS SQL Server, along with best practices for high-performance database management and optimization.

Job Description

• Database Administration: Manage and maintain AWS RDS SQL Server instances, ensuring high availability and reliability.
• Performance Optimization: Optimize queries, indexes, and stored procedures to improve execution time and system performance.
• Partitioning & Sharding: Implement and maintain table partitioning strategies for efficient data handling and faster retrieval.
• Indexing Strategies: Design and manage Clustered, Non-Clustered, Full-Text, and Columnstore Indexes for optimized performance.
• Query Optimization: Analyze and refactor complex SQL queries, ensuring minimum response time and efficient execution plans.
• Faster Data Retrieval: Implement caching, indexing, materialized views, and query hints to enhance query response time.
• Database Design & Schema Management: Design scalable, well-structured database schemas to support large-scale data processing.
• Pagination & Data Handling: Develop efficient pagination techniques to handle and display large datasets effectively.
• Data Security & Compliance: Implement data encryption, masking, and auditing to ensure security and compliance.
• Backup & Recovery: Develop backup strategies, failover mechanisms, and disaster recovery plans.
• Monitoring & Troubleshooting: Utilize tools like AWS CloudWatch, SQL Profiler, Performance Monitor, and Extended Events for proactive database monitoring.
• Collaboration: Work closely with developers, data engineers, and DevOps teams to ensure seamless data integration and optimization.

Technical Skills

• Database Technologies: AWS RDS SQL Server, SQL Server 2016/2019/2022
• Query Optimization: Execution Plans, Query Store, Dynamic SQL
• Indexing: Clustered, Non-Clustered, Columnstore, Full-Text Indexing
• Partitioning: Horizontal & Vertical Partitioning, Table Partitioning
• Performance Monitoring Tools: SQL Profiler, Extended Events, DMV Queries
• Data Handling & ETL: SSIS, Bulk Insert, BCP, Linked Servers
• Backup & Replication: Always On Availability Groups, Log Shipping, Mirroring
• Security & Compliance: Encryption, GDPR, HIPAA Compliance, Row-Level Security
• Scripting & Automation: PowerShell, T-SQL, Stored Procedures, Functions
• Cloud & DevOps: AWS RDS, AWS Lambda, S3 Integration, CI/CD for Databases

Preferred Qualification

• Experience with multi-terabyte databases and distributed database architectures.
• Strong understanding of big data processing and analytics.
• Experience with NoSQL databases like MongoDB is a plus.
• Knowledge of CI/CD pipelines for database deployments.
• Familiarity with data lake architecture and AWS Redshift.
• Ability to work in a fast-paced, data-driven environment.

Education

• Masters/bachelor’s degree in computer science, information systems, or equivalent work experience.

Why Join Us

• Work on large-scale, high-performance databases with cutting-edge technology.
• Be part of a dynamic and innovative team focused on database excellence.
• Work in a collaborative and innovation-driven environment.
• Continuous learning and career growth opportunities.