Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of company databases.
Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues;
Formulates and implements backup procedures for all company databases;
Perform database related development as dictated by departmental or project demands;
Experience with cloud database technologies (i.e. AWS RDS, Oracle, MS SQL, Azure)
Familiarity with AWS Cloud products (EC2, EBS, S3, Lambda, Aurora, Dynamo DB, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.); Exposure to the automation tools /scripting or processes;
Knowledge of PostgreSQL and Oracle;
Solid technical experience as a Database Administrator, as well as excellent interpersonal and communication skills;
DB Concept on Security, Backup and recovery strategies, performance tuning, System Copies, high availability and disaster recovery strategy, export-import, replication is must;
TYPE OF EXPERIENCE YEARS OF EXPERIENCE
4 6 years of increasing responsibility administering, optimizing, and maintaining PostgreSQL and Oracle databases.
Demonstrated skill of formulating best practice recommendations for database operations, including backup strategy, data security and cloud platform.AWS Cloud Database Technologies DynamoDB,AWS CLI, EC2, EBS, S3, Lambda, Aurora, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.
Automation tools Puppet, Ansible, AWS Cloudformation, Terraform, Kubernetes
Database Querying Languages, PostgreSQL, Oracle Log Analysis
Database cloud observability/monitoring tools splunk,solawinds
Bachelor s degree with a strong academic record.