POSITION SUMMARY: We are looking for SQL developer with knowledge on PostgreSQL database administration, who will be working with development team, to provide technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, optimizing and efficiently managing technology using tools and scripting.
ESSENTIAL FUNCTIONS:
• Participate in application development projects and be responsible for the database modeling, database design, data profiling, and data querying.
• Develop procedures, functions, packages, triggers, collections, indexes, constraints, views, sequences, optimized queries using joins and subqueries in support of application development.
• Responsible for
• SQL performance tuning - Ability to understand execution paths, applying hints and optimizing them.
• ETL using SQL - Extract, transform and Load data in bulk from and to database tables
• Transaction design - Ability to design optimal transactions understanding locking, logging and other requirements.
• Responsible for the monitoring, uptime of all production databases and manage data security and privacy.
• Responsible for regular databases maintenance activities(e.g., Vacuum, Re-indexing, Archiving, Monitoring, alerting, and error analysis on logs).
• Responsible for regular backups and recovery of databases, includes PITR (Point in time recovery) based on the requirement.
• Responsible for Configuring replication setup between Production and DR sites.
• Responsible for applying patches (version upgrades) to PostgreSQL.
• Participate in a 24×7 support and perform other duties as assigned.
EDUCATION EXPERIENCE AND SKILLS REQUIRED:
• Graduated in technical discipline or equivalent professional experience in computer science (BE / B.Tech / M.Tech / MCA / M.Sc) and a minimum of 4 years relevant experience.
• Must have strong analytical, verbal and written communication skills.
• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
• Must have strong knowledge of Linux, CentOS.
• Demonstrates ability to solve moderately complex technical problems independently.
• Experience with application deployment by using CI/CD.
• Experience with Docker deployment
DESIRABLE SKILLS:
• Basic understanding on GIS, spatial database (PostGIS) and queries.
• Knowledge on issue tracking/ticketing systems like Jira, ADO.
• Proficient understanding of code versioning tools such as Git, SVN
• Knowledge on scripting languages like Python, shell scripting (e.g., Bash, Perl)
• Basic knowledge of apache2, nginx, and tools like icinga, munin, ansible, puppet.
• Technical certifications.