Demo

Database Administrator (On-site, NY Tri-State Area)

Redan LLC
New York, NY Full Time
POSTED ON 1/29/2025
AVAILABLE BEFORE 4/25/2025

Database Administrator (On-site, NY Tri-State Area)

Redan LLC is looking for a Database Administrator to be part of a growing team.

The Database Administrator will support full systems life cycle applications development on various computer platforms, including a variety of client eligibility and recertification systems, employment / work engagement services, and claims systems with established standards, ensuring all solutions align with the agency's mission and objectives.

Candidates must have excellent written and oral communication skills and be adaptive to the changing needs of the organization. This candidate must have experience with building and maintaining highly effective relationships with team members and multiple stakeholders across multiple projects.

What You'll Be Doing

As the Database Administrator at Redan, you will :

  • Implement conceptual design to physical database implementation, enhance and refine the logical design of the database.
  • Monitor and manage SQL Servers and databases on a day-to-day basis; develop database designs, stored procedures, triggers, and constraints for new applications in MS SQL Server based on client standards.
  • Provide day to day advice to users on data structures and terminology and develop policies and procedures related to the support and maintenance of database applications.
  • Monitor databases for optimal performance and act to mitigate blocking and performance tuning issues.
  • Provide guidance to Application Development staff for query, stored procedures, functions, and database design.
  • Engage in aseline system performance and monitor for deviation, recommending and implementing improvements to slow running queries.
  • Document database architecture, configuration settings, baseline performance metrics and planned and unplanned outages.
  • Establish and implement best practices regarding data definition, data quality, data security, and data integration.
  • Perform database administration duties, including installation, patching, backup and recovery management, space management, schema management, startup, and shutdown.

Profile of Success

Required :

  • Minimum 4 Years Technical expertise in writing optimal T-SQL queries, stored procedures, User defined functions and views. In depth knowledge and hands-on experience developing, deploying, and maintaining complex SSIS packages.
  • Minimum 4 Years thorough understanding of database maintenance practices, including index management, backup strategies and disk space requirements. Knowledge of Microsoft systems, i.e., Windows 2012, 2019, IIS, SQL Server 2012 and 2014, Access, MS. Experience with backups, restores and recovery models.
  • Minimum 4 Years of work in Azure environment like Migration SQL databases from om premise to Azure Cloud. Worked in creating Azure data factories and creating synapse by implementation and configuration. Implemented pipeline creation from Azure synapse to Data verse. Pipeline created between azure synapse to SQL database using data factories.
  • Minimum 4 Years involvement in all environments Production and Test and Dev. Having work experience with cluster environment & fail over, fail back activity @ the time of patching. Having work experience on Availability groups creations and fail over, fail back activity.
  • Minimum 4 Years Handled Tempdb / Version store is different situations. Worked on replication, Database Mirroring and for high availability solutions.
  • Minimum 4 Years Experience in installing, managing, monitoring, and troubleshooting of MS SQL Server 2008R2 / 2012 / 2014 / 2016 / 2019. SQL Server Security and Object Permissions Management like Maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Minimum 4 Years Having experience on Moving system & User defined databases data and log files. Moving the backup from one environment to another environment (Database refresh). Creating Maintenance Plans to perform index de-fragmentation, re-indexing and update the index statistics.
  • Conditions of Employment

  • US Citizenship or Green Card is required.
  • A minimum of 4 years' position-related experience is required.
  • Must be able to work on-site.
  • Strong written and verbal communication skills.
  • Compensation

    Redan offers a package of compensation and benefits to full-time salaried employees.

    Redan, LLC is an Equal Opportunity Employer, and we highly value the diversity of our workforce. We accept resumes from all interested parties and consider applicants for all positions without regard to race, color, religion, sex, national origin, age, marital status, sexual preference, personal appearance, family responsibility, the presence of a non-job-related medical condition or physical disability, matriculation, political affiliation, veteran status, or any other legally protected status.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Database Administrator (On-site, NY Tri-State Area)?

    Sign up to receive alerts about other jobs on the Database Administrator (On-site, NY Tri-State Area) career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $66,897 - $84,160
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $130,034 - $179,473
    Income Estimation: 
    $150,731 - $188,044
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Redan LLC

    Redan LLC
    Hired Organization Address New York, NY Full Time
    Business Analyst (On-site, NY Tri-State Area) Redan LLC is looking for a Business Analyst to be part of a growing team. ...
    Redan LLC
    Hired Organization Address New York, NY Full Time
    Job Description Job Description System Administrator (On-site, NY Tri-State Area) Redan LLC is looking for a System Admi...
    Redan LLC
    Hired Organization Address Brooklyn, NY Full Time
    Business Analyst (On-site, NY Tri-State Area) Redan LLC is looking for a Business Analyst to be part of a growing team. ...
    Redan LLC
    Hired Organization Address Brooklyn, NY Full Time
    Redan LLC is looking for a Project Manager to be part of a growing team. The Project Manager will support full systems l...

    Not the job you're looking for? Here are some other Database Administrator (On-site, NY Tri-State Area) jobs in the New York, NY area that may be a better fit.

    Database Administrator

    Barrow Wise Consulting, New York, NY

    Database Administrator

    VEN SOFT LLC, New York, NY

    AI Assistant is available now!

    Feel free to start your new journey!