Unix Linux System Administrator

PruTech Solutions, Inc.; New York (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

PruTech Solutions, Inc. is hiring a Database Administrator to manage SQL Server environments across development, test, and production.

You will design schemas, implement replication and high availability, develop complex T-SQL, and collaborate with system admins and vendors to keep databases secure and efficient. The role requires at least 6 years of SQL Server experience, including performance tuning, backups, and cloud services.

Qualifications

• A minimum of 6 years of experience in SQL Server database management and related products.
• Proficient in advanced SQL queries, execution plans, SSRS/SSIS, and performance tuning.
• Experience with Always On availability, replication, log shipping, and capacity planning.

Responsibilities

• Develops, maintains, and documents SQL Server infrastructure and standards.
• Architects and configures large databases with replication and high availability.
• Performs tuning, capacity planning, and writes efficient queries and procedures.
• Creates and maintains databases for development, QA, staging, and production.
• collaborates with system administration and vendors to optimize environments.

Skills

SQL Server administration

Query performance tuning

High availability / replication

Database design & schema

SQL development (T-SQL)

Data migration & backups

Cloud DB services (AWS/Azure)

Tools

SSRS

SSIS

SQL Server

MySQL

PostgreSQL

Oracle

Job description

Founded in 1998, PruTech is dedicated to problem-solving, creating solutions, and maintaining strong partnerships with its clients. PruTech serves a diverse list of clients in different industries from government to finance, retail, and manufacturing. PruTech has offices in New York City, Washington DC, North Carolina, and two nearshore offices in Mexico City and India.

With over 20 years of Information Technology and system integration experience, PruTech provides multiple ways to assist organizations with future technology requirements including:

• Project based system integration
• Custom software solutions
• Package implementations
• Consulting and advisory services
• Big data and analytics
• Nearshore and offshore services

PruTech Solution is looking to hire Database Admin.

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

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.