Database Administrator (Oracle (PL/SQL) + PostgreSQL DBA)

Database Administrator (Oracle (PL/SQL) + PostgreSQL DBA)Location: 44 Holland Ave., Albany, NY or 330 Fifth Ave., New York, NY 10001 Maintain responsibility for implementing and maintaining OPHE complex Oracle and AWS PostgreSQL databases. Analyze the design, development, and delivery or implementation of data solutions, including architecture design, prototyping of concepts to proof of concept, analysis of the development of standards, design, and test plans, code, module design development and testing, data solution debugging, design and implementation of a solution that follows efficient design techniques, and development that meets and exceeds the intent of the design of the data solution. Assist with the planning and engineering of the OPHE databases. Monitor performance, scalability, and security and evaluate existing database design to determine the necessary updates and integration requirements of a new design and to ensure final solutions meet OMH OPHE needs.ResponsibilitiesInstall, Configure, Administer, Maintains, Develops and implements policies and procedures for ensuring the security and integrity of all varieties of databases.Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, capacity issues, replication, and other distributed data issuesFormulates and implements backup procedures for all OPHE cloud databasesPerform database related development as dictated by departmental or project demandsDevelop Oracle stored procedure, packages, and triggers to support applications and integrate in-house applications with cloud-based softwareExperience with Cloud database technologies, preferably AWSStrong experience with AWS Cloud products (EC2, EBS, S3, Lambda, Aurora, Dynamo DB, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.)Strong experience with the automation tools /scripting or processesMust have DB Concept on Security, Backup and recovery strategies, performance tuning, System Copies, high availability and disaster recovery strategy, export-import, replicationHands-on experience with operating high-uptime Databases in both AWS and On-premises environmentsMust have experience with performance management/measurement methods, tools, and techniquesQualificationsMinimum QualificationsAt least 8+ years of increasing responsibility Administering, Optimizing, and maintaining relational databases PostgreSQL and Oracle DBAt least 8+ years of with SQL and Oracle PL/SQL utilizing Packages, Types, Objects, Triggers and Advanced Queuing utilizing Oracle version 19c and aboveto support web API and applications.Experience designing and implementing logical and physical database models, including indexes, primary keys, foreign keys, and constraintsProficiency in database management systems such as Oracle and PostgreSQLStrong SQL programming skills and experience with query optimization techniquesDemonstrated skill of database operations, including backup strategy, data security and Cloud platformProficiency in JSON and PostgreSQL support for JSON.Experience performing Extract, Transform, and Load (ETL) techniquesExperience with AWS Cloud Database Technologies (DynamoDB, AWS CLI, EC2, EBS, S3, Lambda, Aurora, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.)Experience in Automation tools (Puppet, Ansible)Experience in Log Analysis, Database cloud observability/monitoring tools (Splunk, solar winds)Bachelor’s degree in Computer or Information technology.RegardsVinay Svinay.s@themesoft.com