The Job

Technical Specialist - SQL Server

Teknik, data och digitalt · Data, AI och analys · Data engineering · Databasadministration

Gå med för uppdateringar

I korthet

Seeking an experienced Database Architect with 9+ years of experience to design, implement, and manage enterprise-scale database solutions on-premises and in AWS. This role requires expertise in PostgreSQL, RDBMS, performance tuning, cloud migration, high availability, and disaster recovery, with close collaboration across technical teams.

Ansvarsområden

  • Design scalable, secure, and highly available database architectures for enterprise applications.
  • Define database standards, architecture guidelines, and best practices across development and production environments.
  • Lead database modernization and migration initiatives from legacy databases to AWS-managed database services.
  • Architect and administer PostgreSQL and other RDBMS platforms in both on-premises and AWS cloud environments.
  • Design High Availability (HA), Disaster Recovery (DR), backup, and replication strategies.
  • Perform database capacity planning, performance tuning, indexing, partitioning, and query optimization.
  • Evaluate and recommend appropriate database technologies based on application and business requirements.
  • Collaborate with application architects, developers, and DevOps teams during solution design and implementation.
  • Design secure database environments, implementing encryption, authentication, authorization, and auditing controls.
  • Define monitoring, alerting, and health-check mechanisms for production databases.
  • Review database designs, schemas, stored procedures, and SQL code for performance and scalability.
  • Lead database upgrade, patching, migration, and version management activities.
  • Develop automation for database provisioning, deployment, backup, and maintenance activities.
  • Troubleshoot complex database issues and provide root cause analysis (RCA) for production incidents.
  • Mentor database administrators and development teams on database design best practices.
  • Architect and design AWS RDS PostgreSQL solutions for product and project delivery, guiding the team in developing robust, secure, and scalable database applications.
  • Serve as a Subject Matter Expert (SME) in AWS RDS PostgreSQL, providing technical guidance, performance tuning, and troubleshooting expertise to resolve complex database-related issues.
  • Research and adopt new technologies and features relevant to AWS RDS PostgreSQL and AWS cloud services, ensuring solutions remain current, enhance quality standards, and meet evolving client requirements.
  • Train and mentor team members on AWS RDS PostgreSQL best practices, including database design, query optimization, security, backup, recovery, and high availability, fostering a continuous learning environment and mitigating delivery risks.
  • Collaborate with stakeholders to gather specifications and customize AWS RDS PostgreSQL solutions that address specific business needs, performance objectives, and technical requirements.
  • Review and evaluate project deliverables for compliance with AWS RDS PostgreSQL standards, security policies, and operational best practices, ensuring high-quality outcomes.
  • Recommend and implement initiatives for client value creation, leveraging AWS RDS PostgreSQL capabilities and AWS-managed services to drive efficiency, optimize performance, and enhance operational effectiveness.

Krav

  • Expert Knowledge Of PostgreSQL Server Architecture, Database Design, And Performance Tuning.
  • Strong Understanding Of Sql Programming, Query Optimization, And Data Modeling.
  • Proficiency In Database Security, Backup Strategies, And Disaster Recovery Planning.
  • Excellent Problem-Solving Abilities And Experience In Troubleshooting Complex Database Issues.
  • Familiarity With Etl Processes And Tools, As Well As Reporting Solutions Related To Sql Server.
#Database Architect#SQL Server#PostgreSQL#AWS#RDBMS#Cloud Migration#High Availability#Disaster Recovery#Database Security#Performance Tuning#Amazon RDS#Amazon Aurora
HCLTech Logo

Företag

HCLTech

Publicerade jobb

för 3 veckor sedan

Anställningstyp

Heltid

Arbetsform

På plats

Erfarenhetsnivå

Senior

Platser

Hyderabad, India

Sökande

Ansök tidigt