Jobs
>
Princeton

    SQL Database Administrator - Princeton, United States - Legal services company

    Legal services company
    Legal services company Princeton, United States

    2 weeks ago

    Default job background
    Description

    Job Description

    Job Description

    Job Type

    Full-time

    Description

    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.

    Requirements

    • 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 is 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, maintenance, and DR planning.
    - 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.
    - Create, modify, and optimize SQL Server Agent jobs and maintenance plans.

    • Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs, and resolve issues.

    • Troubleshoot application slowness and performance issues.
    - Perform SQL Server integration with enterprise applications.

    • Experienced in Database Design and Development

    WORKING CONDITIONS

    Normal business office conditions. Working for prolonged periods of time at a computer screen. Hybrid schedule including in-office and remote work.



  • Fusion Plus Solutions Inc. Edison, United States

    Database Administrators · - Contact UsEdison NJ · Wed, 15 May 2024 · Job Overview · Responsible for Database designing, Data modeling, Application Server, Oracle, DB-2, SQL, PL/SQL packages, procedures, functions and triggers using Oracle 11g/12c. Server, Sybase, OEM, BMC-PATROL, ...


  • COMPUNNEL SOFTWARE GROUP INC. Plainsboro, United States

    Coordinate physical changes to computer databases and codes, tests and implement physical database. Design logical physical databases. Code database descriptions and specifies users to access data bases; Reviews, Tests and correct errors; Modifies database programs to increase pr ...


  • PIONEER CONSULTING SERVICES, LLC Princeton, United States

    Administration, installation, configuration and troubleshooting of Oracle Database Systems and performance; configure, manage, and maintain disaster recovery solutions including backing up and restoring data, and user access management and security. Skills: Oracle Database 12C, 1 ...


  • Resource Informatics Group Princeton, United States

    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 · ...


  • Resource Informatics Group Inc Princeton, United States

    Job Description · Job 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 · • Wor ...


  • Phoenix Innovations Manville, United States

    Come join the SHL Group and share with us the passion for telemedical healthcare. Through our work, we strengthen the self-management of many people's health and thus improve their quality of life. Our services complement traditional medical care and enable a safer approach to he ...


  • Verus LLC Princeton, United States

    Job Type · Full-time · Description · 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 ...


  • Fiserv, Inc. Berkeley Heights, United States

    **Calling all innovators - find your future at Fiserv.** · We're Fiserv, a global leader in Fintech and payments, and we move money and information in a way that moves the world. We connect financial institutions, corporations, merchants, and consumers to one another millions of ...


  • EMSL Cinnaminson, United States

    EMSL is seeking a **Junior Database Administrator (DBA) **in **Cinnaminson, NJ**. This position is responsible for assisting the Senior DBA in maintaining EMSL's database security, performance, report customization, and quality control. The Junior DBA will be heavily involved in ...


  • BCforward Pennington, United States

    Database Administrator - PostgreSQL · BCforward is currently seeking a highly motivated Database Administrator - PostgreSQL for an opportunity in Pennington, NJ 08534 · Position Title: Database Administrator - PostgreSQL · Location: Pennington, NJ 08534 · Anticipated Start Da ...


  • Cynet Systems Princeton, United States

    Pay range: $44 - $49 · Job Description: Manage the entire DB function with a large team of resources in alignment with customer expectations. · Experience with Oracle RAC 11g/12c/19c (Administration/Upgrade/ Patching). · Oracle Client (Administration/Upgrade/ Patching). · Dis ...


  • Legal Services Corporation Princeton, United States

    Job Description · Job Description · Job Type · Full-time · Description · 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 ...


  • JobRialto Plainsboro, United States

    Job Description: · Design, develop, test, and implement system database applications. Design logical physical databases. Tests and corrects errors; Modifies database programs to increase processing performance using Oracle Developer Tools, Application Server, SOL, and other rela ...


  • JobRialto Plainsboro, United States

    Job Description: · Design logical and physical databases. Code database descriptions and specifies users to access databases; Reviews, Tests and correct errors; Modifies database programs to increase processing performance using Oracle/Sybase/SQL, and other related technologies. ...


  • JobRialto Plainsboro, United States

    Job Description: · Design, develop, test, and implement system database applications. Design logical physical databases. Tests and corrects errors; Modifies database programs to increase processing performance using Oracle Developer Tools, Application Server, SOL, and other rela ...


  • Rutgers University New Brunswick, United States

    Rutgers, The State University of New Jersey, is seeking a Database Administrator for the Division of Institutional Planning & Operations (IP&O). The position will join IP&O ITs Application Development team to provide Oracle and SQL Server database a Database Administrator, Databa ...


  • GOMIAPP, LLC Defunct Piscataway, United States

    Install, Configure, Administer and Troubleshoot Microsoft SQL server, Oracle and other enterprise level database servers. Tune, Optimize and Load balance the database server, monitor various code used for stored procedures and functions and coordinate with network team for high p ...


  • Palvai Global Services, Inc. South Plainfield, United States

    DATABASE ADMINISTRATOR - Palvai Global Services, Inc. - South Plainfield, NJ South Plainfield, NJ & various unanticipated locations throughout the U.S.: Instal, confgur, maintan, upgrd & migrt databs servrs. Crt, modfy & mang usrs, grups, conections, asign rols & privilgs & secur ...


  • Plymouth Rock Assurance Woodbridge Township, United States

    Senior Database Administrator · As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Re ...


  • Diverse Lynx Iselin, United States

    Job Title :: DB2 Database Administrator · Location :: Plano, TX (Onsite Rotational) · Job Description : · Skills Needed - DB2, Production Support, Monitoring, L1, L2, L3, DB Joins, LEW Offer DBA DB2 support for application development team. · Ensure integrity, availability and ...