Designs, develops, optimizes, and supports enterprise Oracle and PostgreSQL database solutions. Responsibilities include SQL and PL/SQL programming, performance tuning, Linux Shell scripting, database migrations, deployments, troubleshooting, data validation, and automation. Collaborates with application, QA, infrastructure, migration, and support teams across development, testing, and production environments.
JOB OVERVIEW:
Responsible for designing, developing, optimizing, and supporting enterprise database solutions primarily using Oracle and PostgreSQL. The role requires strong database programming and Shell scripting skills, with experience in database support, troubleshooting, migration, and performance optimization considered an advantage.
CORE DELIVERABLES:
- Design, develop, and maintain scalable and reliable database solutions using Oracle and PostgreSQL.
- Develop and optimize complex SQL queries, stored procedures, functions, triggers, and other database components.
- Good understanding of relational database concepts, database design, indexing, query optimization, and performance tuning.
- Develop and maintain Linux Shell scripts for database processing, automation, deployments, and operational activities.
- Perform database performance analysis and tuning to ensure efficient and reliable application performance.
- Participate in database migrations, data conversions, upgrades, deployments, and data validation/reconciliation activities.
- Troubleshoot and resolve database-related issues across development, testing, and production environments.
- Collaborate effectively with application development, QA, infrastructure, migration, and support teams to deliver database solutions on schedule.
- Identify opportunities for automation, standardization, and reusable solutions to improve productivity and reduce manual effort.
Responsibilities may evolve over time, and other duties may be assigned to support team and business objectives.
ESSENTIAL ATTRIBUTES AND CAPABILITIES:
- Strong analytical, troubleshooting, and problem-solving skills.
- Strong database programming and development mindset with attention to performance, scalability, and maintainability.
- Excellent communication skills with the ability to collaborate effectively with technical and non-technical stakeholders.
- Effectively demonstrates a commitment to quality and a “do it right the first time” mindset.
- Strong preference for automating repetitive database and operational activities.
- Ability to analyze complex technical problems and develop effective and sustainable solutions.
- Experience and ability to collaborate with multiple teams across development, QA, infrastructure, and support functions.
- Ability to work independently, remotely, and as part of a team.
- Knowledge and working experience with Agile software development methodologies.
REQUIRED QUALIFICATIONS AND TECHNICAL EXPERTISE:
- Bachelor’s degree in Engineering, Computer Science, Information Technology, or a related technical discipline.
- Minimum 5+ years of relevant experience in database development/programming.
- Strong hands-on experience with Oracle Database development and programming.
- Strong hands-on experience with PostgreSQL development and programming.
- Strong knowledge of SQL and PL/SQL, including complex queries, stored procedures, functions, triggers, and database objects.
- Strong knowledge of Linux Shell scripting will be a big plus.
- Experience with database deployment, data processing, data migration/conversion, and data validation activities.
- Ability to troubleshoot databases and application-related issues and perform root cause analysis.
PREFERRED QUALIFICATIONS AND EXPERIENCE:
- Experience in database/application production support and troubleshooting is an advantage.
- Experience with Oracle and PostgreSQL performance tuning, including query optimization and execution plan analysis.
- Experience with large-scale database migration, data conversion, or application upgrade projects.
- Experience developing automation utilities/scripts for database operations and repetitive activities.
- Exposure to enterprise applications involving high-volume data processing and complex database environments.
- Experience working with cross-functional and geographically distributed teams.
- Exposure to cloud database environments and database migration technologies is an added advantage.
Similar Jobs
Artificial Intelligence • Consumer Web • Digital Media • Information Technology • Social Impact • Software
Lead the AI Quality engineering team while remaining hands-on building evaluation infrastructure, observability tooling, diagnostic systems, datasets, annotation workflows, and CI/CD pipelines for production AI agents. Run experiments across prompts, models, routing, caching, and agent harnesses to improve quality, latency, and cost. Partner with AI Core engineering and manage technical direction and team priorities.
Top Skills:
Ai AgentsBraintrustCi/CdLangsmithLlmsPythonRuby On Rails
Information Technology • Consulting
Lead ServiceNow ITOM engineering for complex customer projects. Gather requirements, design and implement customizations, configure workflows and applications, develop integrations, create service maps, support testing and production remediation, and mentor engineers. Maintain documentation, promote updates across environments, and guide customers on technical solutions. Requires extensive ServiceNow ITOM implementation, administration, configuration, development, integration, scripting, and technical documentation experience.
Top Skills:
Business RulesClient ScriptsETLFlow DesignerJdbcMid ServerOdbcRestScript IncludesScripted Rest ApisServicenowServicenow ItomSoapUi Builder
Biotech
Leads DevOps strategy and execution across development, QA, and production environments. Builds CI/CD pipelines, manages infrastructure as code, administers container orchestration platforms, and improves system reliability, scalability, security, and performance across cloud and on-premises environments. Collaborates with engineering and operations teams, troubleshoots deployment issues, ensures governance compliance, and mentors junior engineers.
Top Skills:
AnsibleArgocdAWSAzure DevopsBashCloudFormationDockerElkGitlab CiGitopsGrafanaIso 27001IstioJenkinsKubernetesLinkerdPowershellPrometheusPythonSoc 2Terraform
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
