PLSQL / PostgreSQL Developer 3Di Systems

4.0 - 8.0 years

0 Lacs

navi mumbai, maharashtra

On-site

As a Senior Database Administrator based in Navi Mumbai, India, your primary responsibility will be to create and manage multiple databases while assisting in capacity planning. You will play a crucial role in monitoring and maintaining database systems, as well as troubleshooting any issues that may arise. Ensuring data integrity, monitoring security, and managing roles and permissions of database users will be key aspects of your daily tasks. Utilizing tools like Profiler for database tuning, generating traces, execution plans, and identifying performance issues will be vital in your role. Your expertise in resolving problems such as deadlocks and contention will be highly valued. You will be expected to develop strategies and implement solutions for managing backups, restoration, and replication processes. Additionally, creating and managing constraints and indexes will be within your scope of responsibilities. Supporting software developers with database operations, including complex SQL development, DML tuning, and stored procedure creation, will be part of your collaborative efforts. Proactive housekeeping, archiving, and shrinking of databases will be essential tasks for ensuring optimal database performance. Managing production, QA, and development database environments will require your attention to detail and organization skills. Your ability to create detailed documentation, including diagrams of database infrastructure, will be crucial for effective communication and knowledge sharing. To excel in this role, you will need to learn relevant business processes, understand data flow, criticality, and dependencies. Coordinating and communicating effectively with internal teams and clients will be necessary for successful project outcomes. With 4 to 6 years of experience in database administration, you will bring valuable expertise to this position. This position offers a permanent, full-time employment opportunity in Navi Mumbai, India. Apply now to join our team as a PLSQL Trainee and make a significant impact in the field of database administration.,

Posted 1 month ago

Apply

Postgres SQL EDB Innominds Software Inc

6.0 - 10.0 years

0 Lacs

Delhi, India

On-site

Job Description: As a Senior Database Administrator, you will be responsible for managing and maintaining highly available EDB PostgreSQL and MySQL database environments. Your role will include database architecture design, performance tuning, replication setup, backup and recovery, and ensuring data security. You will also provide expertise in cloud migrations and ensure database environments meet high availability and disaster recovery requirements. Key Responsibilities: Database Management: Install, configure, and maintain EDB PostgreSQL and MySQL databases. Manage database schemas, perform upgrades, and apply patches. Monitor database health, availability, and performance across multi-node clusters. Ensure high availability and disaster recovery setups using replication, clustering, and failover mechanisms. Performance Tuning and Optimization: Conduct performance tuning and optimization for SQL queries, indexes, and overall database design. Monitor and optimize resource utilization (CPU, memory, storage) for both EDB PostgreSQL and MySQL. Troubleshoot and resolve performance bottlenecks and database-related application issues. Backup and Recovery: Implement robust backup strategies, including full, incremental, and point-in-time backups. Plan and perform database recovery operations to ensure minimal data loss. Use tools such as pgBackRest, WAL archiving, MySQL dump, and physical and logical backup techniques. Replication and Clustering: Set up and maintain replication (e.g., streaming replication, logical replication) and clustering solutions. Configure and manage failover solutions to enhance database resilience and availability. Administer and troubleshoot EDB Postgres Advanced Server tools like EFM (EDB Failover Manager), PG Pool, and PG Bouncer. Database Security and Compliance: Implement security best practices, including role-based access control and encryption. Ensure compliance with regulatory and security standards. Manage user access and permissions securely. Database Cloud Migration: Lead cloud migration projects to AWS, GCP, or Azure. Design and implement strategies for minimal-downtime migrations. Leverage cloud-native features to optimize performance and scalability. Automation and Scripting: Develop and maintain scripts for database automation tasks using Bash, Python, or SQL. Use monitoring tools and write custom scripts to proactively identify issues. Collaboration and Documentation: Work closely with development teams to optimize database interactions. Document database architectures, processes, configurations, and troubleshooting guidelines. Provide training and guidance to junior DBAs. Technical Skills: Database Platforms: EDB PostgreSQL, PostgreSQL, MySQL. Tools: pgBackRest, WAL, pgBouncer, PG Pool, PEM, MySQL Workbench, MySQL replication, EFM, and monitoring tools like Zabbix, Nagios, or Prometheus. Scripting: Proficiency in SQL, Bash, Python, or other automation languages. Cloud Platforms: AWS, GCP, Azure (experience with cloud-specific database services preferred). Security: Strong knowledge of database security protocols and compliance standards. Operating Systems: Linux (preferably Ubuntu, CentOS, or RHEL) and Windows Server. Soft Skills: Strong problem-solving and analytical skills. Effective communication and teamwork abilities. Proactive approach to learning and applying new technologies. Occasional on-call availability for emergency troubleshooting and support. Education: BE OR BTech or MCA or MTech only Interview Rounds: 2 or 3 Technical rounds Experience Level: 6 to 10 Years

Posted 3 months ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.