Steneral Consulting
Hybrid Work - Need Lead Oracle & Postgres DBA with AWS Cloud in Princeton NJ
Steneral Consulting, Princeton, New Jersey, us, 08543
Onsite 3 days per week; must be within a 60-mile radius of Princeton, NJ.
Need valid LinkedIn profile.
Possible final face-to-face interview.
Candidate must have proven experience with both Oracle and Postgres databases.
Team size: 10 DBAs supporting both Oracle and Postgres.
Manager Notes:
Lead Oracle DBA and Postgres need full DBA skills on both databases.
They are 100% on Oracle 19c.
Oracle is the dominant platform, but Postgres is the growing environment.
Migrating Oracle databases to Postgres.
They are 100% on AWS (EC2, RDS, REDSHIFT, SCT, DMS, S3, SNS, EBS, Lambda, Elastic DRS, AWS Backup, Storage Gateway, FSx, CloudWatch, etc.).
Moving towards infrastructure as code.
Automation Skills (Ansible, Git CI/CD pipeline, Liquibase, Maven).
Oracle is on the Infra side (Server & DB Provisioning, backups/recoveries, DB performance, ElasticDR, DataGuard, DevOps GitLab, CICD, Maven, tools to automate DB deployments).
All aspects of Postgres Admin & RDS on application and infrastructure.
Oracle on Linux.
Python scripting.
Formal Job Description:
Requires extensive knowledge and experience with administering Oracle 19c, PostgreSQL, Aurora PostgreSQL, and SQL Server databases in AWS.
10 to 15 years of progressively responsible DBA administration experience.
Candidates should have expertise in all areas of Oracle and Postgres DBA administration. Must be comfortable supporting databases on EC2 and RDS. Strong AWS coding skill set in delivering Infrastructure as Code solutions for database-related services. Experience with Oracle to Postgres migrations is a plus.
Ability to lead project teams, including operations, application developers, and vendors, to improve technical infrastructure, security, reliability, and cost.
A diverse and extensive technical DBMS background with considerable experience in physical database design, DBMS tools, client/server applications, and data warehousing are required.
Experience with NoSQL databases.
Extensive experience in implementing and supporting H/A systems using Oracle standby, Always On SQL Server, Amazon Aurora Global databases.
Expertise in designing solutions related to Cloud Database Architecture (AWS).
Experience with core AWS services like EC2, RDS, REDSHIFT, SCT, DMS, S3, SNS, EBS, Lambda, Elastic DRS, AWS Backup, Storage Gateway, FSx, CloudWatch, and CloudTrail.
Experience with automation tools (Ansible, Jenkins, Git CI/CD pipeline, Liquibase, Maven).
Experience with server, network, and storage performance optimization.
Demonstrated knowledge of DevOps Principles.
Proficient in using Git branching, push/pull requests, and advanced Git workflows.
Experience with cloud orchestration tools like AWS CloudFormation and/or Terraform.
Strong scripting experience in Python, Ansible, and PowerShell/Bash.
Knowledge in Linux and Windows system administration.
Extensive experience in Linux and Windows scripting skills.
Ability to express complex technical concepts effectively both verbally and in writing.
Ability to work well with people across many different disciplines with varying degrees of technical expertise.
Provide technical expertise to design business solutions related to DBMS "Internals", DBMS tools and utilities usage, database backup and recovery, database performance, and overall database performance monitoring and tuning.
Ensure that data access and database designs are as efficient as possible by coordinating transaction access path analysis sessions with application developers and analyzing specifications and code.
Fully utilize CASE tools to develop or modify physical database designs from logical designs.
Perform database structure migrations.
Troubleshoot database and/or software problems as they apply to design, implementation, or installation activities.
Act as the bridge between database and system-level integration issues and set clear direction for others to follow.
Assure quality of database analysis and design across projects, thus enabling company-wide data reusability.
Schedule and coordinate infrastructure and database maintenance activities including database reorganizations and restructuring.
Coordinate and/or participate in database stress tests, analyze results, and make recommendations for design or coding changes based upon those results.
Participate in on-call and overnight production support and problem resolution activities.
Develop and maintain DBMS-related standards and procedures to facilitate the identification and implementation of quality improvement initiatives.
Research, evaluate, and test new software and DBMS-related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
Assume responsibility for the security of company information through secure databases and monitoring environments to identify improper access and ensure compliance with all security and audit standards.
Act as a Subject Matter Expert (SME) in the hardware, operating system, network, and database arenas and provide consultation and knowledge transfer as needed.
Monitor current DBMS performance and capacity and develop procedures to improve the DBMS environment.
Lead and mentor teams of other Infrastructure or application DBA staff to solve technical database and system challenges.
Collaborate with other application DBA staff, senior infrastructure DBA staff, developers, and other technical staff to ensure that best practices are followed for relational database design, database configurations, and installation options.
Direct and mentor teams of DBA staff.
Function autonomously on a regular basis, seeking direction from senior management in atypical situations.
Issue direction to both technical and non-technical staff and monitor security of data.
Frequently looked to for innovative or inventive business solutions.
Adhere to ethical standards and comply with the laws and regulations applicable to your job function.
Bachelor's degree in Computer Science with extensive coursework in an information processing curriculum, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary.
#J-18808-Ljbffr
Need valid LinkedIn profile.
Possible final face-to-face interview.
Candidate must have proven experience with both Oracle and Postgres databases.
Team size: 10 DBAs supporting both Oracle and Postgres.
Manager Notes:
Lead Oracle DBA and Postgres need full DBA skills on both databases.
They are 100% on Oracle 19c.
Oracle is the dominant platform, but Postgres is the growing environment.
Migrating Oracle databases to Postgres.
They are 100% on AWS (EC2, RDS, REDSHIFT, SCT, DMS, S3, SNS, EBS, Lambda, Elastic DRS, AWS Backup, Storage Gateway, FSx, CloudWatch, etc.).
Moving towards infrastructure as code.
Automation Skills (Ansible, Git CI/CD pipeline, Liquibase, Maven).
Oracle is on the Infra side (Server & DB Provisioning, backups/recoveries, DB performance, ElasticDR, DataGuard, DevOps GitLab, CICD, Maven, tools to automate DB deployments).
All aspects of Postgres Admin & RDS on application and infrastructure.
Oracle on Linux.
Python scripting.
Formal Job Description:
Requires extensive knowledge and experience with administering Oracle 19c, PostgreSQL, Aurora PostgreSQL, and SQL Server databases in AWS.
10 to 15 years of progressively responsible DBA administration experience.
Candidates should have expertise in all areas of Oracle and Postgres DBA administration. Must be comfortable supporting databases on EC2 and RDS. Strong AWS coding skill set in delivering Infrastructure as Code solutions for database-related services. Experience with Oracle to Postgres migrations is a plus.
Ability to lead project teams, including operations, application developers, and vendors, to improve technical infrastructure, security, reliability, and cost.
A diverse and extensive technical DBMS background with considerable experience in physical database design, DBMS tools, client/server applications, and data warehousing are required.
Experience with NoSQL databases.
Extensive experience in implementing and supporting H/A systems using Oracle standby, Always On SQL Server, Amazon Aurora Global databases.
Expertise in designing solutions related to Cloud Database Architecture (AWS).
Experience with core AWS services like EC2, RDS, REDSHIFT, SCT, DMS, S3, SNS, EBS, Lambda, Elastic DRS, AWS Backup, Storage Gateway, FSx, CloudWatch, and CloudTrail.
Experience with automation tools (Ansible, Jenkins, Git CI/CD pipeline, Liquibase, Maven).
Experience with server, network, and storage performance optimization.
Demonstrated knowledge of DevOps Principles.
Proficient in using Git branching, push/pull requests, and advanced Git workflows.
Experience with cloud orchestration tools like AWS CloudFormation and/or Terraform.
Strong scripting experience in Python, Ansible, and PowerShell/Bash.
Knowledge in Linux and Windows system administration.
Extensive experience in Linux and Windows scripting skills.
Ability to express complex technical concepts effectively both verbally and in writing.
Ability to work well with people across many different disciplines with varying degrees of technical expertise.
Provide technical expertise to design business solutions related to DBMS "Internals", DBMS tools and utilities usage, database backup and recovery, database performance, and overall database performance monitoring and tuning.
Ensure that data access and database designs are as efficient as possible by coordinating transaction access path analysis sessions with application developers and analyzing specifications and code.
Fully utilize CASE tools to develop or modify physical database designs from logical designs.
Perform database structure migrations.
Troubleshoot database and/or software problems as they apply to design, implementation, or installation activities.
Act as the bridge between database and system-level integration issues and set clear direction for others to follow.
Assure quality of database analysis and design across projects, thus enabling company-wide data reusability.
Schedule and coordinate infrastructure and database maintenance activities including database reorganizations and restructuring.
Coordinate and/or participate in database stress tests, analyze results, and make recommendations for design or coding changes based upon those results.
Participate in on-call and overnight production support and problem resolution activities.
Develop and maintain DBMS-related standards and procedures to facilitate the identification and implementation of quality improvement initiatives.
Research, evaluate, and test new software and DBMS-related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
Assume responsibility for the security of company information through secure databases and monitoring environments to identify improper access and ensure compliance with all security and audit standards.
Act as a Subject Matter Expert (SME) in the hardware, operating system, network, and database arenas and provide consultation and knowledge transfer as needed.
Monitor current DBMS performance and capacity and develop procedures to improve the DBMS environment.
Lead and mentor teams of other Infrastructure or application DBA staff to solve technical database and system challenges.
Collaborate with other application DBA staff, senior infrastructure DBA staff, developers, and other technical staff to ensure that best practices are followed for relational database design, database configurations, and installation options.
Direct and mentor teams of DBA staff.
Function autonomously on a regular basis, seeking direction from senior management in atypical situations.
Issue direction to both technical and non-technical staff and monitor security of data.
Frequently looked to for innovative or inventive business solutions.
Adhere to ethical standards and comply with the laws and regulations applicable to your job function.
Bachelor's degree in Computer Science with extensive coursework in an information processing curriculum, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary.
#J-18808-Ljbffr