JobCubby JobCubby
Sign up
I

Database Administrator 57

Innovative Computer Solutions Group, Inc New York, New York, United States · $135K/yr

Yesterday
dba Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Database Administrator will design, architect, and maintain complex database environments including Oracle and SQL Server systems. They are responsible for ensuring data integrity, security, performance tuning, and managing database infrastructure across development, QA, and production environments.

What they look for

Oracle SQL Server Database Administration Database Design Performance Tuning SSRS SSIS PowerShell Windows Server Replication High Availability MySQL PostgreSQL MongoDB AWS Microsoft Azure

Requirements

Candidates must have a minimum of 6 years of experience in database management, specifically with SQL Server versions and Windows Server environments. Proficiency in advanced SQL querying, performance tuning, and high availability configurations is required.

Full description

Database Administrator  57 

 

PROJECT DESCRIPTION: ITS serves all DSS program areas to fulfill their IT needs. To meet the business needs and ITS' workload, ITS is seeking qualified candidates in the areas of Database design, architecture, and development, including base definition, structure, documentation, long-range requirements, operational guidelines, and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of various systems that ITS supports across DSS program areas.

 

Tasks & Duties

  • Create and maintain Oracle Databases. Report and make recommendations on database improvements. Ensure current database security standards are maintained
  • Responsible for SQL Server Database development and support.
  • Creates, maintains, and updates SQL Server Infrastructure and Standards DBA documentation.
  • Works with vendors to architect, design and configure large, complex databases with replication and high availability on the most current MSSQL versions.
  • Develops and maintains application, data, and execution architectures.
  • Provides input into overall development/implementation plan and documents database builds and changes, performs SQL designs, table designs, and stored procedures work.
  • Manages large tables, maintains schemas, and develops queries and utilities to assist users.
  • Installs upgrades and patches to existing databases.
  • Creates databases, tuning, cloning, copying, and data refreshes.
  • Performs system analysis and identifies solutions to technical problems
  • Identifies bottlenecks and performs database tuning.
  • Create and maintains all databases required for development, QA, Staging and production usage
  • Install new versions of the SQL Server and its tools.
  • Performs the capacity planning required to create and maintain the databases and carry out tuning of database instances.
  • Work closely with system administration staff because Computers often have applications or tools on them in addition to SQL Server databases
  • Experience with Windows Server environments
  • Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
  • Extensive experience with database replication (Qlik/Attunity)
  • Experience with cloud services (AWS, Microsoft Azure) 

 

Required Skills 

A minimum of 6 years of experience with the following skill sets:

·        SQL 2008/2008R2/2012/2014/2016/2019/2022 database management and related products

·        Microsoft includes PowerShell, Windows Server operating systems.

·        Advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS packages. 

·        SQL Server Always on High Availability configuration, support, and troubleshooting.

Performance tuning, Performance monitoring, “Live” and Scheduled replication, Log shipping, Database Mirroring, Database capacity planning, Users and Role creation and monitoring

Similar roles