Senior Data Architect - SQL/PostgreSQL (7-10 yrs)

Role : Sr Data Architect/DBA

Location : Hyderabad / Bangalore, India

Technologies : MySQL, PostgreSQL, AWS, RDS, Redshift, S3, PL/SQL, MySQL Architecture, Data Modeling

Responsibilities :

- As a Data Architect, you'll play a pivotal role in driving technical excellence with our dynamic teams

- Collaborating closely with product, design, architects, and engineers, you'll lead the design, implementation and ongoing management of our data resources and cutting-edge solutions

- Data Modeling : Understand current data utilization, methods and models in order to architect a new data model that supports current product capabilities including reporting and future data analysis

- Governance : Develop and enforce data governance policies and best practices to ensure data integrity and compliance

- Collaboration : Work closely with product owners, designers, architects and platform engineers to define scope and drive the implementation of new features from conception to release

- Continuous Improvement : Regularly evaluate and enhance the data architecture to adapt to evolving business needs

- Leadership : Provide leadership and strategic direction for data-related projects and initiatives

- Quality Assurance : Ensure data quality, integrity, and consistency across all data systems and processes

- Audits & Assessments : Conduct regular assessments and audits of the data architecture and related processes to ensure compliance and efficiency

- Hands-on Administration : Responsible for ensuring data sources are being backed up and restorable

- Ensure monitoring is in place and analyze metrics on a regular basis to guarantee up-time, recognize anomalous activity, and forecast possible issues by observing changes in resource utilization patterns

- Hands-on Assistance : Work with engineers to develop stored procedures, troubleshoot existing ORM performance issues, and aid in the retrieval of data for troubleshooting

- Assist in platform deployments to ensure that database upgrades run smoothly and ensure that data is being populated as expected

- Database Design and Performance Tuning : Familiar with AWS RDS and Serverless SQL clusters

- Will be responsible for building views, access patterns, and stored procedures for performant and secure data access by the application later

- Disaster Recovery : Responsible for data fix and real-time database rollback plan to manage data corruption

- Responsible for maintaining backup and restore strategy for the databases

- Cost Management : Responsible for maintaining and extending cost control automation for the data sources

Qualifications :

- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field

- 5-7+ years of proven experience as a Data Architect/DBA in an AWS environment

- Extensive experience in data modeling, database design, data governance, and data warehousing

- Experience in managing and optimizing databases with MySQL, DynamoDB, ElasticSearch, Athena, and Postgres

- Strong knowledge of AWS cloud platform including services such as RDS, Redshift, S3 and Quicksight

- Proficient in performance tuning, query optimization, database backup and recovery procedures

- Proven leadership and communication skills

- Solid database concepts and database design knowledge (ACID, abstraction levels, schemas and constraints, stored procedures, replication, etc.)

- Strong troubleshooting skill in database performance analysis and improvements.

- Good knowledge of storage, networking, and other systems directly impacting database performance.

- Solid experience in the administration and performance tuning of database-related tools and environments

- Excellent problem-solving abilities and attention to detail

- Leadership Experience : Demonstrating effective leadership and mentorship, fostering innovation, and driving successful outcomes through collaborative decision-making

- Communication Excellence : Excelling in keeping peers and stakeholders informed, particularly during critical customer-impacting scenarios

- Demonstrating the ability to convey complex technical concepts clearly and succinctly

- Agile Affinity : Seamlessly incorporating Agile/Scrum methodologies into project workflows, fostering adaptability and efficiency within the team

- Problem Solving : Exhibiting an unparalleled knack for tackling intricate, ambiguous challenges head-on

- Detail-Oriented : Exceptionally meticulous and attentive to every detail