Senior Database Administrator

Posted:
9/20/2024, 3:40:13 AM

Location(s):
Western Province, Sri Lanka ⋅ Colombo, Western Province, Sri Lanka

Experience Level(s):
Senior

Field(s):
IT & Security ⋅ Software Engineering

Workplace Type:
Hybrid

Kaleris is a private equity-backed software firm focused on supply chain optimization, headquartered in Atlanta, Georgia. We are a global leader in the supply chain execution market, focused on accelerating the transformation of digital supply chain for industrial and finished goods shippers and carriers by combining best-in-class solutions for challenges tied to yard management, shipment visibility, and asset management, across rail, truck, and multi-mode transportation 

Kaleris seeks a motivated and detail-oriented Senior Database Administrator to join our team. As a Database Administrator, you are primarily responsible for automating, maintaining, optimizing, monitoring, and troubleshooting our databases (PostgreSQL / MSSQL / MySQL) in our Public Clouds AWS and Azure. Additionally, you will handle requests and problem escalations from other departments and work closely with our DevOps and CloudOps Engineers.  

Responsibilities 

  • Maintain and optimize database systems including PostgreSQL, MSSQL, and MySQL to ensure high levels of performance and availability. 
  • Monitor resource-intensive queries and expensive table joins, creating and tuning indexes to improve performance. 
  • Develop and maintain database scripts, jobs, and monitoring automation to streamline administrative tasks and enhance efficiency. 
  • Handle database replication activities utilizing AWS Database Migration Service (DMS) to ensure data consistency and availability across different environments. 
  • Apply and review database changes (DDL/DML) as part of the CI/CD pipeline, ensuring changes are deployed smoothly and efficiently. 
  • Design, monitor, and operate disaster recovery solutions with techniques such as backups, replications, and Point-in-Time Recovery (PITR) to safeguard data against loss. 
  • Manage Role-Based Access Control for databases to enhance the security posture by ensuring only authorized users have access to specific database functions. 
  • Respond to escalations and system alerts from monitoring systems as required, ensuring quick diagnosis and resolution of issues. 
  • Define, document, and communicate standards, best practices, and technology decisions regarding database management to stakeholders within the organization. 

Requirements 

  • Educational and Professional Experience 
  • Bachelor’s degree in Computer Science, IT, or a related field, or any other equivalent qualification. 
  • 5+ years of professional experience, with at least 3 years in a production SQL Developer / DBA role 
  • Technical Skills 
  • Experience managing cloud-managed databases such as Amazon RDS or Azure Managed Instances, including PostgreSQL, MSSQL, and MySQL. 
  • Proficiency in SQL tuning, with the ability to provide recommendations and a deep understanding of SQL (DDL/DML). 
  • Experience with scripting using Bash, Batch, or PowerShell to automate tasks and processes. 
  • Sound knowledge of network protocols including TCP/IP, DNS, SSH, HTTP(S), and (S)FTP. 
  • Familiarity with networking/distributed computing environment concepts. 
  • Soft Skills and Abilities 
  • Multitasking and independent work capability, with the ability to drive projects with minimal supervision. 
  • Quick learning skills for new technologies and skills. 
  • Customer service orientation and good interpersonal skills. 
  • Analytical and problem-solving skills. 
  • Proficiency in English (spoken and written) for communication in global teams. 
  • Optional Qualifications 
  • Cloud-related certifications are considered an added advantage. 
  • Basic knowledge of Infrastructure as Code (IaC) tools, such as Terraform. 
  • Familiarity with Liquibase is a plus. 
  • Knowledge of Kafka 
  • Experience with change management processes, such as ITIL.  

Benefits & Compensation  

  • Competitive compensation package  
  • Paid Leave (Vacation/Annual, Casual, Volunteering time off)  
  • Hospitalization Insurance   
  • Life & Accident Insurance   
  • Broadband Allowance, IT gadgets Allowance  
  • Meal & Fuel Allowance   
  • Provident Fund  
  • Tuition Reimbursement  
  • Employee Assistance Program   
  • Career growth and mentorship 

The duties and responsibilities described are not a comprehensive list and additional tasks may be assigned from time to time or the scope of the position may change necessary to business demands. 

We are an equal-opportunity employer and value diversity at Kaleris. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. 

*We do not accept unsolicited external resumes from outside, third-party sources*