Cloud Database Administrator

General information
- Country

India
- State

Telangana
- City

Hyderabad
- Job ID

42842
- Department

SaaS
- Description & Requirements

A Senior Database Administrator with expertise in PostgreSQL, automation skills, AWS would be responsible for the following tasks:
A Day in The Life Typically Includes:
1. Management and maintenance of multiple databases, including PostgreSQL, Cassandra, MSSQL Server and OpenEdge, to ensure their optimal performance, security, and reliability.

2. Design and implementation of automation strategies to streamline database administration processes and minimize manual errors, utilizing AWS CLI and other scripting languages.

3. Deployment and management of databases on Amazon Web Services (AWS), including Amazon RDS, Amazon Aurora, EC2 instances, and S3 storage.

4. Implementation of data backup and recovery strategies, disaster recovery plans, and high availability solutions using AWS services.

6. Design and implementation of security protocols, such as firewalls, encryption, and role-based access control, to protect sensitive data in AWS and Azure.

8. Management of database schema updates and version control.

9. Monitoring and reporting of database performance metrics, and identification of trends and potential issues.

10. Mentorship and supervision of junior database administrators.

11. Writing and documenting the technical runbooks, processes and procedures.

12. Taking part in performing monthly consolidated maintenances during office hours and after office hours to perform patching, updates and upgrades on Database resources.

Required skills:
1. US Citizen / Permanent Resident (Greencard holders)

2. Strong experience with PostgreSQL database administration, including performance tuning, backup and recovery, and security.

3. Knowledge of MSSQL server with handling day to day database activities.

4. Experience with AWS services, such as RDS, EC2, S3, IAM, and AWS CLI.

5. Experience with automation and scripting tools such as Shell, Powershell, and Python.

6. Excellent problem-solving and analytical skills.

7. Strong knowledge of SQL and ability to write complex queries.

8. Experience with database migration and replication.

9. Good understanding of database architecture and design.

10. A bachelor's or master's degree in computer science, engineering, or a related field.

11. Strong communication and collaboration skills, with the ability to work with cross-functional teams.

Preferred Qualifications:
1. Knowledge of database automation using tools like Ansible, Puppet, or Chef is a plus.

2. Knowledge of MSSQL Server, Cassandra, OpenEdgeis a big advantage.

3. Knowledge and experience of other RDBMS such as SQL Server and Oracle is a plus.

4. Knowledge of government compliances and standards such as GDPR and HIPPA is a plus.

Knowledge of monitoring tools such as Monocle, Sumologic, Splunk, CloudWatch is a plus
- About InforInfor is a global leader in business cloud software products for companies in industry specific markets. Infor builds complete industry suites in the cloud and efficiently deploys technology that puts the user experience first, leverages data science, and integrates easily into existing systems. Over 60,000 organizations worldwide rely on Infor to help overcome market disruptions and achieve business-wide digital transformation. Our ValuesAt Infor, we strive for an environment that is founded on a business philosophy called Principle Based Management (PBM) and eight Guiding Principles: integrity, stewardship & compliance, transformation, principled entrepreneurship, knowledge, humility, respect, self-actualization. Increasing diversity is important to reflect our markets, customers, partners, and communities we serve in now and in the future.We have a relentless commitment to a culture based on PBM. Informed by the principles that allow a free and open society to flourish, PBM prepares individuals to innovate, improve, and transform while fostering a healthy, growing organization that creates long-term value for its clients and supporters and fulfillment for its employees.