RDS SQL Server Database Developer & Administrator

SummaryWe 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 DescriptionDatabase 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 SkillsDatabase Technologies: AWS RDS SQL Server, SQL Server 2016/2019/2022Query Optimization: Execution Plans, Query Store, Dynamic SQLIndexing: Clustered, Non-Clustered, Columnstore, Full-Text IndexingPartitioning: Horizontal & Vertical Partitioning, Table PartitioningPerformance Monitoring Tools: SQL Profiler, Extended Events, DMV QueriesData Handling & ETL: SSIS, Bulk Insert, BCP, Linked ServersBackup & Replication: Always On Availability Groups, Log Shipping, MirroringSecurity & Compliance: Encryption, GDPR, HIPAA Compliance, Row-Level SecurityScripting & Automation: PowerShell, T-SQL, Stored Procedures, FunctionsCloud & DevOps: AWS RDS, AWS Lambda, S3 Integration, CI/CD for DatabasesPreferred QualificationExperience 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.EducationMasters/bachelor’s degree in computer science, information systems, or equivalent work experience.Why Join UsWork 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.