Senior Database Administrator

Custom Software Engineer

Project Role : Custom Software Engineer
Project Role Description : Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.
Must have skills : PostgreSQL Administration
Good to have skills : Microsoft SQL Server Administration
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education

Database Administrator III

JOB SUMMARY:
The Database Administrator (DBA) will be responsible for the development, performance, integrity, and operations of database systems . As a DBA you will work with engineering teams to educate about best practices and lead implementation of ideal queries and database structures. client runs several RDBMS systems, including PostgreSQL, MS SQL Server and Oracle. This position requires the ability to work independently, as well as in collaboration with others to implement solutions.



ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES:
Operational Database Management
Monitor database performance, conduct regular performance tuning, and optimize queries, query patterns, and system for maximum efficiency
Install, configure, and upgrade database software and related tools
Develop and implement database backup and recovery strategies to ensure data reliability and minimize downtime.
Manage routine maintenance tasks, such as database backups, index rebuilding, and statistics gathering.
Manage and optimize critical production databases to ensure the availability and reliability of critical databases to ensure optimization and best practices.

Engineering Database Expertise and Best Practices
Work with engineering teams to implement database related best practices
Review SQL queries for optimal implementation to prevent production issues
Recommend database techniques such as prepared statements, indexes, and/or cursors to assist and educate engineering teams

Performance Optimization and Troubleshooting
Identify and resolve database performance issues, such as slow queries, inefficient indexing, or resource contention.
Conduct database capacity planning to anticipate future storage and performance needs.
Implement and maintain database monitoring tools to proactively identify and resolve issues.


SUPERVISORY RESPONSIBILITIES:
N/A



KNOWLEDGE, SKILLS AND ABILITIES:
Strong verbal and written communication skills with the ability to collaborate well within a team and across organizations.
Strong Experience implementing and managing PostgreSQL and SQL Server databases with automation and configuration management tools and techniques.
Experience in scripting/deployment languages such as PowerShell, Python, Go, Terraform
Experience with deployment, configuration, and maintenance of PostgreSQL on Amazon Aurora Serverless v2 RDS and RDS for SQL Server
Experience building and maintaining highly available database environments with cross site/region failover.
Experience performing advanced tuning of PostgreSQL and SQL Server for high volume throughput.
Ability to design, deploy, and manage database services on cloud platforms like AWS and Azure.
Experience with Software as a Service (SaaS) environments including architecture and management.
Understanding of security best practices when architecting and deploying databases.
Experience developing SQL queries to support troubleshooting and reporting in a live production environment.
Participate in an on-call rotation in support of production environments
Performing occasional off-hours or weekend work as needed.



EDUCATION AND TRAINING:
BS in computer science, Information Technology, or a related field.
Minimum of 5+ years of proven work experience as a Database Administrator
Strong knowledge of database management systems, such as Microsoft SQL Server, PostgreSQL, and Oracle
Proficiency in writing complex SQL queries and optimizing database performance.
Knowledge of Cloud Infrastructure, particularly AWS and Azure



Other Qualifications
The Winning Way behaviors that all employees need in order to meet the expectations of each other, our customers, and our partners.
Communicate with Clarity - Be clear, concise and actionable. Be relentlessly constructive. Seek and provide meaningful feedback.
Act with Urgency - Adopt an agile mentality - frequent iterations, improved speed, resilience. 80/20 rule – better is the enemy of done. Don t spend hours when minutes are enough.
Work with Purpose - Exhibit a We Can mindset. Results outweigh effort. Everyone understands how their role contributes. Set aside personal objectives for team results.
Drive to Decision - Cut the swirl with defined deadlines and decision points. Be clear on individual accountability and decision authority. Guided by a commitment to and accountability for customer outcomes.
Own the Outcome - Defined milestones, commitments and intended results. Assess your work in context, if you re unsure, ask. Demonstrate unwavering support for decisions.


COMMENTS:
The above statements are intended to describe the general nature and level of work being performed by individuals in this position. Other functions may be assigned, and management retains the right to add or change the duties at any time.