Database Administrator (Oracle (PL/SQL) + PostgreSQL DBA) Job at Themesoft Inc., Albany, NY

NUR4V0dReEJub1hnVjl1elhXM3RqYlU4
  • Themesoft Inc.
  • Albany, NY

Job Description

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.

Responsibilities

  • Install, 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 issues
  • Formulates and implements backup procedures for all OPHE cloud databases
  • Perform database related development as dictated by departmental or project demands
  • Develop Oracle stored procedure, packages, and triggers to support applications and integrate in-house applications with cloud-based software
  • Experience with Cloud database technologies, preferably AWS
  • Strong 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 processes
  • Must have DB Concept on Security, Backup and recovery strategies, performance tuning, System Copies, high availability and disaster recovery strategy, export-import, replication
  • Hands-on experience with operating high-uptime Databases in both AWS and On-premises environments
  • Must have experience with performance management/measurement methods, tools, and techniques

Qualifications

Minimum Qualifications

  • At least 8+ years of increasing responsibility Administering, Optimizing, and maintaining relational databases PostgreSQL and Oracle DB
  • At least 8+ years of with SQL and Oracle PL/SQL utilizing Packages, Types, Objects, Triggers and Advanced Queuing utilizing Oracle version 19c and above
  • to support web API and applications.
  • Experience designing and implementing logical and physical database models, including indexes, primary keys, foreign keys, and constraints
  • Proficiency in database management systems such as Oracle and PostgreSQL
  • Strong SQL programming skills and experience with query optimization techniques
  • Demonstrated skill of database operations, including backup strategy, data security and Cloud platform
  • Proficiency in JSON and PostgreSQL support for JSON.
  • Experience performing Extract, Transform, and Load (ETL) techniques
  • Experience 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.

Regards

Vinay S

vinay.s@themesoft.com

Job Tags

Similar Jobs

VNA & Hospice of the Southwest Region Inc

Hi-Tech Registered Nurse (RN) Job at VNA & Hospice of the Southwest Region Inc

 ...Description Job Description VNA & Hospice of the Southwest Region of Rutland, VT is looking to hire a per diem Hi-Tech Registered Nurse (RN) in Rutland County . Are you looking to further your career in home health nursing ? Would you like to work for a... 

The UPS Store

Part-Time Center Associate Sinking Spring Job at The UPS Store

The Part-Time Center Associate delivers world-class customer service to all retail customers by receiving and processing packages for courier shipment and operating copiers, fax machines, binding equipment, laminating machines, and point-of-sale devices. The Associate expertly... 

Express Employment Professionals

No CDL Earn Your Class A For FREE Job Job at Express Employment Professionals

No CDL Earn Your Class A For FREE Job- Work as a team in a busy electrical distribution company in Denver- Initially perform deliveries in a non-class vehicle while in-training to obtain Class A license (CDL paid for by company)- Conduct daily vehicle inspections... 

Re:Build Manufacturing

Advanced Composites Production Specialist Job at Re:Build Manufacturing

 ...Job Description Job Description Build your craft in advanced manufacturing Join a team that turns raw composites into precision parts. In this role, youll run a composite press, set it up for a range of jobs, verify quality, and keep output on target. What you... 

Rethink Food

Trucking Team- Driver Job at Rethink Food

 ...equitable food future for all. ROLE SUMMARY: The Rethink Trucking Team supports transportation for our Commissary Kitchen, Rethink...  ...other related duties as assigned. REQUIREMENTS: Valid Drivers License from the Tri-State area and clean driving record...