Senior Postgres Database Administrator

3 months ago

Marlton, United States Xpanse Full time
  • 10+ years of DBA experience in RDMBS systems, Postgres required, Snowflake
  • 5+ years of experience in NoSQL such as MongoDB, DynamoDB.


Postgres preferred.


Summary:

The Administrator, DBA Sr will be responsible for proactively administering all aspects with both Relational Database Management Systems (RDBMS) and NoSQL systems, including but not limited Oracle, Postgres, MongoDB, Snowflake and Dynamo.

The position is comprised of working with the Enterprise Architect in understanding the architectural roadmaps that support and fulfill business strategy. The DBA will need to stay informed of the ways the organization uses its data and provides designs that are scalable, robust, secure, and efficient database platforms.

Essential Job Duties and Responsibilities:

  • Ownership in installations, creation, management, monitoring, scaling and tuning RDMBS and NoSQL databases for various business units.
  • Day to day management activities of production databases for online system operations including monitoring, troubleshooting, backup, restore, change management, and storage management.
  • Responsible for Database Replay, Partitioning, Schema Management, Resiliency, Virtual columns, Making, and Security.
  • Working knowledge in monitoring, optimization, configuration, troubleshooting, manage data replication, backups, partitioning, and storage management the database platforms.
  • Run performance, management, and tuning tools.
  • Participate in discussions and recommend new strategies for installation, upgrade, configuration, and patching of new and existing RDBMS and NoSQL platforms.
  • Recommend new strategies and architectures for high availability, monitoring, database security, backup, and recovery for large scale databases.
  • Strong knowledge with AWS RDBMS RDS platforms and EC2.
  • Ability to participate in an on-call rotation to provide production support in a 24/7 environment.
  • Comply with all company policies and procedures.
  • Maintain regular and punctual attendance.

Other Job Duties and Responsibilities:

Performs other related duties as assigned.

Supervisory Responsibilities:

This position is an individual contributor with no direct reports but may provide guidance, leadership, or training to others.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

  • Strong Experience in development of stored procedures, packages, triggers, SQL queries, reports, and scripts.
  • Expertise in Database Replay, Partitioning, Schema Management, Caching and Pooling, Resiliency, Masking, and Security.
  • Hands on experience with various performance and tuning tools such as ASH, AWR, STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF and ADDM reports.
  • Proficiency in troubleshooting, performance tuning and SQL optimization.
  • Ability to diagnose problems and resolve issues across various tiers (application, database, network, server, and storage)
  • Strong Experience with data migration, data archiving and data access techniques.
  • Must be able to write SQL and UNIX shell scripts with formatting to serve as evidence for the change management process.
  • Evaluate new database technologies and products and recommend to technical management.
  • Scripting language skills such as Perl, Python, and Bash is a strong plus.
  • Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams.

Education and/or Experience:

  • Bachelor’s degree in computer science or equivalent is preferred.
  • 10+ years of DBA experience in RDMBS systems, such as Oracle, Postgres, Snowflake
  • 5+ years of experience in NoSQL such as MongoDB, DynamoDB.

  • Senior Technical Accounting Manager

    2 weeks ago

    Marlton, United States Gateway Recruiting Full time

    The Senior Technical Accounting Manager supports the assistant and corporate controllers in all aspects of internal, external, and regulatory reporting. This position will interact extensively with SEC, NYSE, external auditors, and other accounting/tax service providers playing a critical role in the timely and accurate reporting and filing of financial...

  • Senior Technical Accounting Manager

    1 week ago

    Marlton, United States Gateway Recruiting Full time

    The Senior Technical Accounting Manager supports the assistant and corporate controllers in all aspects of internal, external, and regulatory reporting. This position will interact extensively with SEC, NYSE, external auditors, and other accounting/tax service providers playing a critical role in the timely and accurate reporting and filing of financial...

  • Certified Nursing Assistant

    4 weeks ago

    Marlton, New Jersey, United States Artis Senior Living Full time

    Job Summary: We are seeking a compassionate and skilled Certified Nursing Assistant to join our team at Artis Senior Living. As a CNA, you will play a vital role in providing exceptional care and support to our residents.Key Responsibilities:Assist residents with daily activities such as bathing, dressing, and eatingMonitor and record vital signs and report...

  • Senior Business Development Manager

    1 week ago

    Marlton, United States Workplace HCM Inc Full time

    Our Senior Business Development Manager will work closely with Sales & Marketing Manager promote and sell Workplace HCM Solutions to new prospects and clients within an assigned geographic area. Responsibilities Qualified candidates will be accountable for the following responsibilities: Research accounts to identify point of contact Follow up on all leads...

  • Senior Interior Designer

    1 month ago

    Marlton, United States Liberty Personnel Services, Inc Full time

    Job DescriptionJob DescriptionSenior Interior Designer An excellent architectural & interior design firm in the Greater Philadelphia area just minutes from the city is actively in search of an experienced Senior Interior Designer.The Senior Interior Designer, you will provide interior design services to clients on a diverse variety of project types & sizes...

  • Senior Interior Designer

    1 week ago

    Marlton, United States Liberty Personnel Services, Inc Full time

    Job DescriptionJob DescriptionSenior Interior Designer An excellent architectural & interior design firm in the Greater Philadelphia area just minutes from the city is actively in search of an experienced Senior Interior Designer.The Senior Interior Designer, you will provide interior design services to clients on a diverse variety of project types & sizes...

  • Senior Architect

    1 month ago

    Marlton, United States Liberty Personnel Services, Inc Full time

    Job DescriptionJob DescriptionSENIOR ARCHITECT Senior Architectural Designer-Architect-Architecture- Architectural Design-Registered Architect Our architectural client in the local area is actively seeking an experienced Architect with an eye for detail, which can utilize their industry expertise, design abilities, and technical acumen to drive projects...

  • Senior Architect

    4 days ago

    Marlton, United States Liberty Personnel Services, Inc Full time

    Job DescriptionJob DescriptionSENIOR ARCHITECT Senior Architectural Designer-Architect-Architecture- Architectural Design-Registered Architect Our architectural client in the local area is actively seeking an experienced Architect with an eye for detail, which can utilize their industry expertise, design abilities, and technical acumen to drive projects...

  • Senior IT Project Manager

    1 month ago

    Marlton, New Jersey, United States Virtua Health Full time

    Job SummaryThe Senior IT Project Manager is responsible for planning, documenting, executing, and finalizing medium to large, complex, multi-departmental or enterprise projects according to the approved scope assessment, project plan, and work breakdown structure (WBS), resource plan, schedule, and budget. This role ensures IT project methodology rigor and...

  • Senior IT Project Manager

    1 month ago

    Marlton, New Jersey, United States Virtua, Inc. Full time

    Job Summary:The Senior IT Project Manager at Virtua Health is responsible for planning, documenting, executing, and finalizing medium to large, complex, multi-departmental or enterprise projects according to the approved scope assessment, project plan, and work breakdown structure (WBS), resource plan, schedule, and budget. This role ensures IT project...

  • Software Development III

    4 weeks ago

    Marlton, New Jersey, United States Volt Full time

    Job Summary:Volt is seeking a skilled Smartsheet Developer to join our team. As a Smartsheet Developer, you will be responsible for designing, implementing, and maintaining Smartsheet solutions for our clients. The ideal candidate will have experience with Smartsheet, strong programming skills, and analytical abilities.Responsibilities:Develop and implement...

  • Travel CT Tech in Marlton, NJ

    2 weeks ago

    marlton, United States Aya Healthcare Full time

    Aya Healthcare has an immediate opening for the following position: CT Tech in Marlton, NJ.We’ll work with you to build the healthcare career of your dreams. Whether you want a job close to home or across the country, we’ve got you.Requirements:Required Certifications: ARRT R, BLS, State licensedRequired Skills: Adult Acute Care, Emergency...

  • Staff Accountant

    3 weeks ago

    Marlton, United States Virtua, Inc. Full time

    At Virtua Health, we exist for one reason - to better serve you. That means being here for you in all the moments that matter, striving each day to connect you to the care you need. Whether that's wellness and prevention, experienced specialists, life-changing care, or something in-between - we are your partner in health devoted to building a healthier...

  • IT Project Manager Lead

    1 week ago

    Marlton, New Jersey, United States Virtua, Inc. Full time

    Job Summary: Virtua Health is seeking a skilled Senior IT Project Manager to lead medium to large, complex, multi-departmental or enterprise-level IT projects.Key Responsibilities: Plan IT projects in collaboration with Operational Leaders, IT Directors, and key stakeholders to define project scope, plan, budget, and timeline.Manage the implementation of IT...

  • Clinical Research Coordinator Sr.

    3 weeks ago

    Marlton, United States CenExel Full time

    About Us: Each of CenExel's research sites specialize in Phase I to Phase IV clinical trials. Our Centers of Excellence comprise some of the most well respected and long-standing research facilities in the country. Specialty areas of research across our sites include Psychiatry, Acute Post Op Pain, Asian Bridging, Dermatology, GI, and Neurology. Each of our...