PostgreSQL Database Administrator

Greetings from Encora Innovation Labs! A leading world class SaaS technology Product Engineering Company!

Encora is looking for PostgreSQL DBA with 6-10 years experience in PostgreSQL, SQL Server, Performance Tuning, Replication, Mirroring, HA, DR, Optimization (PTO), ETL, SSIS and Azure DB

Please find the below detailed job description and the company profile for your better understanding.

Position: Database Admin

Experience: 6-10 years

Position Type: Full time

Qualification: Any graduate

Job Summary:

The DBA will be responsible for the performance of critical SQL Server RDBMS systems and Postgres SQL, to ensure the availability and consistent performance of our enterprise applications. This is a hands-on position requiring solid technical skills, as well as excellent interpersonal and communication skills. The successful candidate will be responsible for the management of high volume, high available enterprise class SQL Server and Postgres SQL database, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modelling in support of multiple development teams. Must be capable of working independently and collaboratively.

Responsibilities :

• Work with the following tools and technologies: MS SQL server administration, Postgres SQL; performance tuning and optimization (PTO) using native monitoring and troubleshooting tools; backup, restore, and recovery models; windows server, including active directory; high availability (HA) and disaster recovery (DR) options for SQL server; and leading cloud platforms like AWS, Azure, or Google Cloud.
• Monitors current usage levels of database storage to identify and report growth trends and assists in the forecasting of future storage requirements. Assists with the development of long-term capacity plans. Performs routine maintenance such as data compression, defragmentation, dropping temp tables, clearing transaction logs, archiving inactive databases, load balancing and evaluating server hardware to provide recommendations for performance improvements.
• Actively monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provides recommendations for corrective actions. Performs database statistic reporting on a regularly scheduled basis. Ensures the high availability of the supported database(s).
• Works closely with the Applications Team while performing troubleshooting to determine the source of application failures. Assists in the development of solutions to minimize the potential of future application failures. Supports the implementation of solutions.
• Produces and maintains operational database documentation, such as SQL Disaster Recovery, SQL Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.
• Configure and maintain database servers and processes, including monitoring of system health

Skills:

• 5+ years of experience in handling MS SQL Server and Postgres Sql
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Monitor databases to gather resource consuming queries, maintain SQL server replication, Clustering, backups, ETL SSIS jobs, and encryption
• Review and debug SQL Server code including adhoc queries, views, stored procedures, functions and triggers for modernization and performance improvements
• Maintain, review and apply appropriate indexes for new and existing queries • Analyze SQL query plans, suggest and implement solutions to support developers in the Software Development Life Cycle (SDLC)
• Review alerts and remediate any issues that may arise from blocking, deadlocks and poorly performing code using extended events, execution plan analysis
• Use PowerShell and SSIS to automate monitoring and alerting functions of SQL server
• Experience with MS SQL Server (2012 or greater) tools, including Query Analyzer, SQL Agent Jobs and Profiler
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Experience working with Windows server, including Active Directory
• Knowledge on Azure DB as a service
• Excellent written and verbal communication
• Flexible, team player, get-it-done” personality
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams

Teamwork:

• Facilitates effective cross functional and cross cultural team interaction
• Acknowledges and appreciates each team member's contributions
• Effectively utilizes each team member to his/her fullest potential
• Keeps track of lessons learned and shares those lessons with team members.

Communication:

• Facilitates team and stakeholder meetings effectively
• Holds regular status meetings / scrum meeting
• Resolves and/or escalates issues in a timely fashion
• Understands how to communicate difficult/sensitive information tactfully
• Astute cross-cultural awareness and experience in working with international teams (especially US)

You should be speaking to us if;

• You are looking for a career that challenges you to bring your knowledge and expertise to bear for designing implementing and running a world class IT organization
• You like a job that brings a great deal of autonomy and decision-making latitude
• You like working in an environment that is young, innovative and well established
• You like to work in an organization that takes decisions quickly, is non-hierarchical and where you can make an impact

Why Encora Innovation Labs?

Are you are looking for a career that challenges you to bring your knowledge and expertise to bear for designing implementing and running a world class SaaS technology IT organization?

Encora Innovation Labs is a world class SaaS technology Product Engineering company and focused on transformational outcomes for leading-edge tech companies. Encora Partners with fast growing tech companies who are driving innovation and growth within their industries.

Who We Are: Encora is devoted to making the world a better place for clients, for our communities and for our people.

What We Do: We drive transformational outcomes for clients through our agile methods, micro-industry vertical expertise, and extraordinary people.

We provide hi-tech, differentiated services in next-gen software engineering solutions including Big Data, Analytics, Machine Learning, IoT, Embedded, Mobile, Cloud, UI/UX, and Test Automation to some of the leading technology companies in the world.

Encora specializes in Data Governance, Digital Transformation, and Disruptive Technologies, helping clients to capitalize on their potential efficiencies. Encora has been an instrumental partner in the digital transformation journey of clients across a broad spectrum of industries: Health Tech, Fin Tech, Hi-Tech, Security, Digital Payments, Education Publication, Travel, Real Estate, Supply Chain and Logistics and Emerging Technologies.

Encora has successfully developed and delivered more than 2,000 products over the last few years and has led the transformation of a number of Digital Enterprises.

Encora has over 20 offices and innovation centers in 15+ countries worldwide. Our international network ensures that clients receive seamless access to the complete range of our services and expert knowledge and skills of professionals globally.

Encora global delivery centers and offices in the United States, Costa Rica, Mexico, United Kingdom, India, Malaysia, Singapore, Indonesia, Hong Kong, Philippines, Mauritius, and the Cayman Islands.

Encora is Certified Great Place to Work in India.

Please visit us at

Website: encora.com

LinkedIn: EncoraInc

Facebook: @EncoraInc

Instagram: @EncoraInc

Office Locations: United States, Costa Rica, Mexico, United Kingdom, India, Malaysia, Singapore, Indonesia, Hong Kong, Philippines, Mauritius, and the Cayman Islands

Interview Levels: 3 Technical Interviews