SQL Database Administrator

2 weeks ago

Princeton, United States Legal services company Full time
Job DescriptionJob 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.

  • SQL server Database Developer

    17 hours ago

    Princeton, United States Diverse Lynx Full time

    Job Title SQL server Database Developer Relevant Experience (in Yrs) 5+ years Technical/Functional Skills Must have: Top-3 Deep knowledge of Relational Databases, Microsoft SQL server and proficient in T-SQL, SSIS and SSRS. (10+ years of experience) Design and Development of high-quality OLAP and OLTP database solutions, Data Warehousing ...

  • MS SQL Server DBA

    6 days 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...

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

  • Pl/SQL Developer

    7 days ago

    Princeton, United States Diverse Lynx Full time

    Job Title:- Pl/SQL Developer Location: - North Chicago ( IL, USA ) (Open Only W2) Job Description: Hands on PL/SQL, and Unix Scripting with a preferred knowledge on Life Science Hub (LSH) and life sciences domain. Technical knowledge and understanding about Clinical Data Warehouse, Reporting and Regulatory Submission requirements as it relates to...

  • Executive Administrator

    7 days ago

    Princeton, United States Lynkx Staffing LLC Full time

    Job DescriptionJob DescriptionLynkx Staffing LLC specializes in placing professionals in the Pharmaceutical and Medical Device industries in New Jersey. Our Pharmaceutical client seeks an Executive Administrator to perform and oversee all administrative related services for the EVP and Head of Quality Assurance. The position requires broad knowledge of...

  • Backup Administrator

    1 week ago

    Princeton, United States Noblesoft Technologies Full time

    Role: NetBackup L3Location: Princeton, NJ – preferredCandidate should have in depth knowledge of Minimum 7-10 years of strong experience in Symantec NetBackup and Networker.Multiple Software Versions- hands on experience Advantages of new over previous, Difference with previous release etc.Backup Architecture, Master server, Media server, Client, Tape...

  • Backup Administrator

    Found in: Appcast Linkedin GBL C2 - 1 week ago

    Princeton, United States Noblesoft Technologies Full time

    Role: NetBackup L3Location: Princeton, NJ – preferredCandidate should have in depth knowledge of Minimum 7-10 years of strong experience in Symantec NetBackup and Networker.Multiple Software Versions- hands on experience Advantages of new over previous, Difference with previous release etc.Backup Architecture, Master server, Media server, Client, Tape...

  • Backup Administrator

    Found in: Appcast US C2 - 1 week ago

    Princeton, United States Noblesoft Technologies Full time

    Role: NetBackup L3Location: Princeton, NJ – preferredCandidate should have in depth knowledge of Minimum 7-10 years of strong experience in Symantec NetBackup and Networker.Multiple Software Versions- hands on experience Advantages of new over previous, Difference with previous release etc.Backup Architecture, Master server, Media server, Client, Tape...

  • ESL Administrative Assistant

    2 weeks ago

    Princeton, United States YWCA Princeton Full time

    Job DescriptionJob DescriptionAt the YWCA Princeton, we are committed to creating an environment where our employees feel included, with a sense of belonging and respect, and are appreciated for their contributions.If you are seeking an exciting opportunity, then look no further!The YWCA Princeton's English as a Second Language seeks a part-time...

  • IT Manager

    7 days ago

    Princeton, United States Five Dimensions Energy Full time

    Job Description Job Description Job Title: IT Manager Location: Princeton, NJ Experience Level: Mid to Senior Company Overview: We are a dynamic and innovative trading company based in Princeton, NJ. Our team is seeking an experienced IT Manager to lead our technology initiatives. The ideal candidate will have a strong background in Microsoft Azure...

  • Senior Windows Systems Administrator

    5 days ago

    Princeton, United States SAIC Full time

    Description SAIC is seeking a Senior Windows Administrator to join our program as a general technologist to support our NOAA GFDL program in Princeton, NJ serving the NOAA GFDL lab in a highly scientific user and mission driven facility. This individual would support both projects (60%) and user (40%) actives in a high interrupt tiered support environment...

  • Senior Windows Systems Administrator

    Found in: beBee jobs US - 2 weeks ago

    Princeton, New Jersey, United States SAIC Career Site Full time

    Description SAIC is seeking a Senior Windows Administrator to join our program as a general technologist to support our NOAA GFDLprogram in Princeton, NJ serving the NOAA GFDL lab in a highly scientific user and mission driven facility. This individualwould support both projects (60%) and user (40%) actives in a high interrupt tiered support environment...

  • ETL Tech lead

    7 days ago

    Princeton, United States Diverse Lynx Full time

    Job Title: ETL Tech lead Location: Remote Duration: Contract DESCRIPTION : ETL Tech lead with Actimize experience 8+ years of Data Warehousing ETL experience using Informatica Power Center 10.x/9.x Experience working on relational databases such as Oracle 10g/9i or SQL Server 2008 Extensive experience with ETL tool Informatica in designing...

  • IT Manager

    7 days ago

    Princeton, United States Five Dimensions Energy Full time

    Job DescriptionJob DescriptionJob Title: IT ManagerLocation: Princeton, NJExperience Level: Mid to SeniorCompany Overview: We are a dynamic and innovative trading company based in Princeton, NJ. Our team is seeking an experienced IT Manager to lead our technology initiatives. The ideal candidate will have a strong background in Microsoft Azure...

  • Senior Java Developer

    7 days ago

    Princeton, United States Damco Solutions Full time

    Exp: Minimum 10+ Years Position will be 100% remote. Program will allow candidates who are within the state (Any location within the State of Texas). No candidates who are currently out of state and are planning to move to Texas with not be considered. Candidates must already reside in Texas. NOTE : Candidate Must Have Previous Work Experience with State of...

  • AWS Databricks Cloud Engineer

    7 days ago

    Princeton, United States CareerBuilder Full time

    AWS Databricks Cloud Engineer - Remote Location: Remote Preferred Time Zones: EST, CST, MTN Rate Type: W2 Length: 1 to 3 years Health Benefits: Available to participate in Cyrtens Health Benefits program after 90 Days 401K: Available to join Cyrtens 401k program after 1,000 hours of work Manager Note: Top 3-5 skills Databricks experience Sql background,...

  • AWS Databricks Cloud Engineer

    7 days ago

    Princeton, United States CareerBuilder Full time

    AWS Databricks Cloud Engineer - Remote Location: Remote Preferred Time Zones: EST, CST, MTN Rate Type: W2 Length: 1 to 3 years Health Benefits: Available to participate in Cyrten's Health Benefits program after 90 Days 401K: Available to join Cyrten's 401k program after 1,000 hours of work Manager Note: Top 3-5 skills 1. Databricks experience 2. Sql...

  • Java Developer

    Found in: beBee jobs US - 7 days ago

    Princeton, New Jersey, United States Kellton Technologies Full time

    Responbilities Responsible for designing implementing coding testing and documenting new programs. Debugging troubleshooting and maintaining source code related to various computer programs. Write functional and unit test code to automatically test the system. Work closely with test engineers to review requirements and system designs and plan for both manual...

  • AWS Databricks Cloud Engineer

    7 days ago

    Princeton, United States Cyrten Full time

    AWS Databricks Cloud Engineer - RemoteLocation: Remote Preferred Time Zones: EST, CST, MTN Rate Type: W2 Length: 1 to 3 years Health Benefits: Available to participate in Cyrten's Health Benefits program after 90 Days 401K: Available to join Cyrten's 401k program after 1,000 hours of work Manager Note: Top 3-5 skills 1. Databricks experience 2. Sql...

  • Tandem Engineer

    2 days ago

    Princeton, United States Cynet Systems Full time

    Pay range: $55 - $65 Job Description: Requirements: 5-7 years development experience on the TANDEM / Client NonStop platform (Client / OSS, COBOL, C, C++, JAVA). ssist in planning, architecture, analysis and design of enterprise technology solutions that satisfy business requirements for large complex systems. Hands-on TANDEM/NonStop X Systems...