Jr SQL DBA

2 weeks ago

Princeton, United States DKMRBH Inc Full time
Job DescriptionJob Description

SQL DBA

Location: Princeton, NJ

3 days on-site, 2 days remote

Long term Contract position

Visa: US Citizen, Green Card only

We are looking for an individual with 3-5 yrs experience

SUMMARY

The SQL DBA is responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems to ensure the availability and consistent performance of our corporate applications. This position requires solid technical skills, as well as excellent interpersonal and communication skills. The SQL DBA is responsible for the development and sustainment of the SQL Server Eco-System, ensuring its operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple development teams. The incumbent will also develop and manage a robust data warehouse to support a suite of program management tools.

PRIMARY RESPONSIBILITIES

  1. Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
  2. Configure and maintain database servers and processes, including monitoring of system health, to ensure optimal performance, availability, and security.
  3. Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  4. Refine and automate regular processes, track issues, and document changes.
  5. Assist developers with complex query tuning and schema refinement.
  6. Perform scheduled maintenance and support release deployment activities.
  7. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  8. Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
  9. Highly skilled at database design, installations, and conversions.
  10. Document and manage database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.
  11. Engage in ongoing process improvement.
  12. Other duties as assigned.

KNOWLEDGE AND SKILL REQUIREMENTS/COMPETENCIES

  • 3+ years MS SQL Server Administration experience required.
  • 3+ years w/ Development and integration of SQL database services in an enterprise environment.
  • 3+ years working w/large databases (1 TB+).
  • 3+ years working in a clustered Windows environment.
  • 3+ years w/ SQL Server Integration Services (SSIS).
  • 3+ years w/ SQL Server Reporting Services (SSRS).
  • MCTS, MCITP, and/or MVP certifications a plus.
  • A working knowledge of Salesforce/MuleSoft/Snowflake would be a plus.
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
  • Excellent written and verbal communication.
  • Flexible, collaborator, "get-it-done" personality.
  • Ability to organize and plan work independently.
  • Ability to work in a rapidly changing environment.
  • Ability to multi-task and context-switch effectively between different activities and teams
  • Experienced in Database Performance, Maintenance and Development to perform the following:
    • Database management including backups, recovery, and maintenance.
    • Database management for export, import and mass data loads.
    • Analyzes and generation of all tables and index statistics.
    • Monitoring and resolving data lock issues.
    • Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes.
    • Create indexes to achieve critical dataset response time for time sensitive reports.
    • Install SQL Server service packs and updates.
    • Configure and manage SQL Security settings.
    • Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer.
    • Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
      • Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs, and resolve issues in a timely manner. Insight
      • Troubleshoot application slowness and performance issues.
    • Perform SQL Server integration with enterprise applications.
    • Experienced in Database Design and Development to perform the following:
      • New projects database design utilizing
    • SQL Stored procedures development, compilation and debugging.

  • Sr. Oracle DBA

    1 month ago

    Princeton, United States VTal Technology Solutions Full time

    Looking for Sr. Oracle DBA - Postgres SQL DBA to work with a nonprofit educational assessment and research organization for a contract role. This is a hybrid role with 2 days onsite availability required. Job Duties & responsibilities: Oracle Application DBA Advanced Oracle database administration skills and experience required. AWS cloud experience...

  • Sr. Oracle DBA

    5 days ago

    Princeton, United States VTal Technology Solutions Full time

    Looking for Sr. Oracle DBA - Postgres SQL DBA to work with a nonprofit educational assessment and research organization for a contract role. This is a hybrid role with 2 days onsite availability required. Job Duties & responsibilities: Oracle Application DBA Advanced Oracle database administration skills and experience required. AWS cloud experience...

  • SQL Database Administrator

    4 weeks ago

    Princeton, United States Legal services company Full time

    Job DescriptionJob DescriptionJob TypeFull-timeDescriptionThe SQL DBA is responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems to ensure the availability and consistent performance of our corporate applications. This position requires solid technical skills, as well as excellent interpersonal and...

  • MS SQL Server DBA

    3 weeks ago

    Princeton, United States eTeam Full time

    12+ years of experience in MS SQL Server Database Administration and Implementation(in OLTP, Web based, Production and Development environments) including Installations and Upgrades. Always On configuration & management for SQL server databases Proficiency with performance optimization /tuning. Good experience using DMV, Query Store Experience in installing...

  • Cache DBA Admin

    3 weeks ago

    Princeton, United States Diverse Lynx Full time

    Role- Cache DBA Admin Location: Pleasanton, CA/Pasadena, CA/Portland, OR/Atlanta, GA (Remote) Duration: Long Term Contract (C2C/W2) Client: TCS Job Title Cache DBA Admin Relevant Experience (in Yrs) 8+ years Technical/Functional Skills Install and configure Cache databases. Performs monitoring and maintenance of Cache databases. Applying...

  • Cache DBA Admin

    5 days ago

    Princeton, United States Diverse Lynx Full time

    Role- Cache DBA Admin Location: Pleasanton, CA/Pasadena, CA/Portland, OR/Atlanta, GA (Remote) Duration: Long Term Contract (C2C/W2) Client: TCS Job Title Cache DBA Admin Relevant Experience (in Yrs) 8+ years Technical/Functional Skills Install and configure Cache databases. Performs monitoring and maintenance of Cache databases. Applying...

  • Jr. Quality Analyst

    2 months ago

    Princeton Junction, United States Meritek Inc Full time

    Jr. Quality Analyst (QA)Meritek Inc. is a well-established company in delivering Software IT solutions to leading clients in the commercial and government sectors. We are headquartered in New Jersey but with our diverse workforce we can provide solutions to our client's requirements virtually anywhere in North America. We provide industry-leading...

  • Jr. Quality Analyst

    2 months ago

    Princeton Junction, New Jersey, United States Meritek Inc Full time

    Jr. Quality Analyst (QA)Meritek Inc. is a well-established company in delivering Software IT solutions to leading clients in the commercial and government sectors. We are headquartered in New Jersey but with our diverse workforce we can provide solutions to our client's requirements virtually anywhere in North America. We provide industry-leading services...

  • Postgresql DBA

    2 weeks ago

    Princeton, United States Amtex Systems Inc. Full time

    Job Title: Sr. PostgreSQL DBA Location – Princeton, NJ (Onsite 4 days/week)Type: FulltimeTechnical Skills:Experienced with PostgreSQL & PostgreSQL Architecture.Understanding of basic Database Fundamentals: Multi-version control, Concurrency, Transactions, Indexing, Locking.Ability to Independently Monitor and Administer databases.Creation & managing...

  • Postgresql DBA

    2 weeks ago

    Princeton, United States Amtex Systems Inc. Full time

    Job Title: Sr. PostgreSQL DBA Location – Princeton, NJ (Onsite 4 days/week)Type: FulltimeTechnical Skills:Experienced with PostgreSQL & PostgreSQL Architecture.Understanding of basic Database Fundamentals: Multi-version control, Concurrency, Transactions, Indexing, Locking.Ability to Independently Monitor and Administer databases.Creation & managing...

  • Postgresql DBA

    2 weeks ago

    Princeton, United States Amtex Systems Inc. Full time

    Job Title: Sr. PostgreSQL DBA Location – Princeton, NJ (Onsite 4 days/week)Type: FulltimeTechnical Skills:Experienced with PostgreSQL & PostgreSQL Architecture.Understanding of basic Database Fundamentals: Multi-version control, Concurrency, Transactions, Indexing, Locking.Ability to Independently Monitor and Administer databases.Creation & managing...

  • Computer Systems Analyst

    2 weeks ago

    Princeton, United States XL Impex, Inc., dba Atika Technologies Full time

    Computer Systems Analyst - XL Impex, Inc., dba Atika Technologies - Princeton,, NJ (Job Code 102): Princeton, NJ & various unanticipated locations throughout the US: Gather, anlyze bus & tech rqrmnts, & dvlp strtgs. Plan & dsgn comp sys to improve oprtinl effic for clients. Work with stakeholders like Product Managers, Lead Engineers, & Dvlprs to help with...

  • Senior MySQL Database Administrator

    44 minutes ago

    Princeton, United States Princeton IT Services Full time

    Job DescriptionJob DescriptionJob Title: Senior MySQL Database Administrator (DBA)Location: Princeton, NJJob Type: ContractJob Summary: We are looking for an experienced Senior MySQL Database Administrator to oversee the design, implementation, maintenance, and optimization of our MySQL database infrastructure. The ideal candidate will have a strong...

  • Oracle Database Administrator

    3 weeks ago

    Princeton, United States Resource Informatics Group Full time

    Job Description Job Description Advanced Oracle database administration skills and experience required. • AWS cloud experience required • Working knowledge of Oracle Data Guard and standby databases • Working knowledge of Oracle Golden Gate and database replication • Working knowledge of some other database technology like MS SQL Server, Postgres, or...

  • Oracle Database Administrator

    1 month ago

    Princeton, United States Resource Informatics Group Inc Full time

    Job DescriptionJob DescriptionAdvanced Oracle database administration skills and experience required.• AWS cloud experience required• Working knowledge of Oracle Data Guard and standby databases• Working knowledge of Oracle Golden Gate and database replication• Working knowledge of some other database technology like MS SQL Server, Postgres, or...

  • Oracle Database Administrator

    1 month ago

    Princeton, United States Resource Informatics Group Inc Full time

    Job DescriptionJob DescriptionAdvanced Oracle database administration skills and experience required.• AWS cloud experience required• Working knowledge of Oracle Data Guard and standby databases• Working knowledge of Oracle Golden Gate and database replication• Working knowledge of some other database technology like MS SQL Server, Postgres, or...

  • Jr. Python Developer

    7 days ago

    Princeton, United States Saxon Global Full time

    Associate Platform/Python Developer Excited to grow your career? At Bristol Myers Squibb, we are inspired by a single vision - transforming patients' lives through science. In oncology, hematology, immunology and cardiovascular disease - and one of the most diverse and promising pipelines in the industry - each of our passionate colleagues contribute to...