Project Role : Infra Tech Support Practitioner
Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting.
Must have skills : PostgreSQL Administration
Good to have skills : NA
Minimum 3 year(s) of experience is required
Educational Qualification : Bachelors degree in computer science information technology or a related field
As a Senior PostgreSQL and MYSQL Database Administrator with 6+ years of experience, you will be responsible for managing and optimizing our PostgreSQL/MYSQL databases to ensure high availability, performance, and security. You will play a critical role in the design, implementation, and maintenance of complex database solutions.
Roles & Responsibilities:
Database Design and Optimization:
Design and implement PostgreSQL database solutions to meet application requirements, considering scalability, performance, and reliability.
Optimize queries and database performance through indexing, query tuning, and appropriate database configuration settings.
High Availability and Disaster Recovery:
Implement and manage replication, clustering, and failover solutions to ensure high availability and disaster recovery capabilities.
Establish and maintain backup and recovery strategies to minimize data loss and downtime.
Security and Compliance:
Implement and enforce security policies, access controls, and encryption mechanisms to maintain data integrity and comply with industry standards and regulations.
Conduct periodic security audits and vulnerability assessments.
Monitoring and Performance Tuning:
Set up monitoring systems to track database performance, identify bottlenecks, and proactively address issues.
Analyze query plans and database performance metrics to optimize and fine-tune the database environment.
Automation and Scripting:
Develop scripts and automation tools to streamline routine administrative tasks and database maintenance processes.
Implement continuous integration and deployment strategies to enhance operational efficiency.
Documentation and Training:
Document database architecture, configurations, procedures, and best practices.
Provide training and mentorship to junior team members, sharing knowledge and expertise in PostgreSQL database administration.
Professional & Technical Skills:
- Must Have Skills: Experience in PostgreSQL Administration, MYSQL, Snow and ITIL knowledge.
- Good To Have Skills: Experience in Linux Administration, Shell Scripting, Networking,Oracle, MSSQL and Amazon Redshift
- Strong understanding of operating systems, hardware, software, and networking.
- Experience in troubleshooting and resolving issues related to PostgreSQL Administration.
- Experience in implementing technology at the operating system-level across all server and network areas.
-Bachelor's degree in computer science, information technology, or a related field.
-6+ years of experience as a Database Administrator with a strong focus on PostgreSQL/MYSQL.
-Proficiency in SQL and PL/pgSQL.
-Experience with PostgreSQL/MYSQL performance tuning, replication, clustering, and disaster recovery solutions.
-Familiarity with PostgreSQL/MYSQL extensions and ecosystem.
-Strong problem-solving and troubleshooting skills.
-Excellent communication and collaboration skills.
- The candidate should have a minimum of 3 years of experience in PostgreSQL Administration.
- The ideal candidate will possess a strong educational background in computer science or a related field, along with a proven track record of delivering impactful solutions.