Job Description

Job Description

Role: Senior Application DBA/Database developer

Location: Bangalore/Chennai (Remote)

Who are we looking for

We are seeking a highly skilled and experienced individual with 8 to 10 years of experience in database administration, development, or related roles to join our team as a senior PostgreSQL DBA and senior database developer. This individual must have extensive experience working with the PostgreSQL database management system, including installation, configuration, optimization, and troubleshooting. Proficiency in database scripting languages such as SQL, and PL/pgSQL for developing complex database solutions and automation tasks. Experience in data conversion and migration projects, including schema migration and data transfer between different database systems. Proficiency in data modeling tools such as ERwin, Toad Data Modeler, or PostgreSQL-specific tools like pgModeler.

Technical Skills:

PostgreSQL Administration:
Advanced knowledge and experience with PostgreSQL database administration.
Installation, configuration, and maintenance of PostgreSQL database instances.
Performance tuning, optimization, and troubleshooting of PostgreSQL databases.
Capacity planning and monitoring of PostgreSQL database servers.
Backup and recovery strategies for PostgreSQL databases.
Database Scripting:
Proficiency in scripting languages such as Python, Bash, or PowerShell for automating database tasks and administration.
Writing and maintaining database scripts for tasks such as data loading, data transformation, and monitoring.
Data Conversion and Migration:
Experience in data conversion and migration projects, including schema migration and data transfer between different database systems.
Knowledge of tools and techniques for migrating data from legacy systems to PostgreSQL databases.
Ensuring data integrity and consistency during the migration process.
Database Design and Modeling:
Strong understanding of database design principles and normalization techniques.
Experience in designing and implementing database schemas for new applications or system enhancements.
Proficiency in data modeling tools such as ERwin, Toad Data Modeler, or PostgreSQL-specific tools like pgModeler.
SQL Queries and Optimization:
Expertise in writing complex SQL queries for data retrieval, manipulation, and reporting.
Knowledge of SQL optimization techniques such as query tuning, indexing strategies, and execution plan analysis.
Familiarity with advanced SQL features and functions available in PostgreSQL.
Database Security and Compliance:
Implementing and maintaining database security policies, access controls, and user permissions.
Ensuring compliance with industry regulations such as GDPR, HIPAA, or PCI-DSS.
Experience with encryption, authentication, and auditing mechanisms in PostgreSQL.
High Availability and Replication:
Setting up and configuring high availability solutions such as PostgreSQL replication, clustering, or failover mechanisms.
Experience with tools like PostgreSQL Streaming Replication, pgpool-II, or repmgr for achieving high availability and fault tolerance.
Version Control and DevOps Practices:
Familiarity with version control systems such as Git for managing database schema changes and scripts.
Experience with DevOps practices and tools for continuous integration and deployment (CI/CD) of database changes.
Performance Monitoring and Alerting:
Implementing monitoring solutions to track database performance metrics, resource utilization, and query execution times.
Setting up alerting mechanisms to proactively identify and address performance bottlenecks or system issues.
Documentation and Knowledge Sharing:
Documenting database configurations, procedures, and best practices.
Providing mentorship and knowledge sharing with junior team members or other stakeholders.

Responsibilities:

Database Administration (PostgreSQL):
Oversee the installation, configuration, and maintenance of PostgreSQL database systems.
Monitor database performance, conduct performance tuning, and optimize SQL queries for efficiency.
Implement and maintain database security measures, including user access controls, data encryption, and backup and recovery strategies.
Troubleshoot database issues, diagnose and resolve database-related problems, and ensure system reliability and uptime.
Plan and execute database upgrades, patches, and migrations, ensuring minimal downtime and data integrity.
Implement database replication, clustering, and high availability solutions for disaster recovery and failover.
Database Development:
Develop and maintain database scripts, stored procedures, functions, triggers, and other database objects to support application development and data processing requirements.
Design and implement data models, database schemas, and indexing strategies to optimize database performance and support application functionality.
Perform data conversion and migration tasks, including data cleansing, transformation, and loading (ETL) processes, ensuring data integrity and consistency.
Collaborate with software developers, architects, and business stakeholders to understand database requirements and provide database solutions that meet business needs.
Conduct code reviews, performance analysis, and database optimization to ensure adherence to best practices and standards.
Document database designs, processes, and procedures, and provide training and knowledge transfer to junior team members.
SQL Query Optimization:
Write and optimize complex SQL queries, stored procedures, and database views to retrieve and manipulate data efficiently.
Analyze query execution plans, identify performance bottlenecks, and implement optimizations to improve query performance.
Utilize database performance monitoring tools and profiling techniques to identify and resolve performance issues.
Database Design and Modeling:
Design and implement logical and physical database models using industry-standard tools and methodologies.
Normalize database schemas and define relationships between tables to ensure data integrity and minimize redundancy.
Conduct data modeling sessions with stakeholders to gather requirements and translate business needs into database designs.
Evaluate and recommend database technologies, tools, and methodologies to support current and future application requirements.
Documentation and Communication:
Create and maintain technical documentation, including database schema diagrams, data dictionaries, and system architecture diagrams.
Communicate effectively with cross-functional teams, including developers, testers, project managers, and business stakeholders, to ensure alignment on database requirements and deliverables.
Participate in meetings, presentations, and discussions to provide insights, recommendations, and updates on database-related activities and projects.
Continuous Learning and Improvement:
Stay informed about emerging trends, technologies, and best practices in database administration, database development, and data management.
Pursue professional development opportunities, such as training courses, certifications, and conferences, to enhance skills and knowledge in database technologies and related areas.

Behavioral Skills:

Problem-solving: Ability to analyze complex database issues, identify root causes, and develop effective solutions.
Attention to detail: Strong attention to detail to ensure accuracy in data conversion, migration, and database design.
Adaptability: Flexibility to adapt to changing priorities, technologies, and business requirements in a dynamic environment.
Collaboration: Ability to work collaboratively with cross-functional teams, including developers, system administrators, and business stakeholders.
Communication: Excellent verbal and written communication skills to effectively communicate technical concepts and solutions to non-technical stakeholders.
Leadership: Demonstrated leadership skills to lead database development projects and mentor junior team members.
Time management: Effective time management skills to prioritize tasks, meet deadlines, and manage multiple projects simultaneously.
Analytical thinking: Strong analytical skills to analyze complex database problems, performance bottlenecks, and optimization opportunities.
Innovation: Willingness to explore and implement innovative solutions to improve database performance, scalability, and reliability.
Continuous learning: Commitment to continuous learning and staying updated with the latest trends, technologies, and best practices in database management and development.

Qualification:

Bachelor's degree in computer science, Information Technology, or related field.
8 to 10 years of experience in database administration, development, or related roles.
PostgreSQL-related certifications, such as Certified PostgreSQL Associate or Certified PostgreSQL Professional, preferred.
Familiarity with cloud database services such as Amazon RDS, Google Cloud SQL, or Azure Database for PostgreSQL.
Excellent problem-solving and analytical skills.
Strong communication skills, both written and verbal.
Ability to work independently and collaboratively in a team environment.
Strong attention to detail and organizational skills.
Ability to prioritize tasks and manage multiple projects simultaneously.
Willingness to learn new technologies and adapt to changing environments.
Proven track record of delivering high-quality solutions on time and within budget

Talent Fulfillment Group JD Format

Senior Application DBA/Database developer (PostgreSQL DBA

Database Developer - PostgreSQL