Database Administrator - Data Engineer

Softthink Solutions; New York (NY); On-site; USD 120,000 - 155,000; Full time

Job summary

Softthink Solutions is hiring a Database Administrator / Data Engineer in New York City to manage SQL Server databases, data integration, ETL processes, performance tuning and security. You will partner with application teams and APIs to ensure reliable, high-quality data operations across the enterprise.

Responsibilities include optimizing queries, maintaining runbooks, and validating data while supporting production environments and data exchanges with other systems.

Qualifications

• Proficient in Microsoft SQL Server 2019+ with strong T-SQL skills.
• Experience developing and optimizing complex SQL queries, stored procedures, views and functions.
• Proven ETL and data integration experience across enterprise systems.
• Experience in production database support and proactive performance tuning and monitoring.

Responsibilities

• Administer and support Microsoft SQL Server databases.
• Develop and optimize SQL queries and stored procedures.
• Support ETL packages and scheduled data-processing activities.
• Troubleshoot database and production data issues.
• Analyze complex data issues across integrated applications.
• Support data exchanges between enterprise systems.
• Perform data validation and reconciliation.
• Monitor and optimize database performance.
• Support database design and data-access requirements.
• Maintain database documentation and technical runbooks.
• Support data security and access controls.
• Participate in root-cause analysis and knowledge-transfer activities.

Skills

SQL Server 2019+

Advanced SQL development

Stored procedures, views, functions

ETL/data integration

Database performance tuning

Data validation and reconciliation

Enterprise production database support

APIs collaboration with dev teams

Job description

Database Administrator / Data Engineer

Location: New York city, NY
Work Authorization: US Citizen

Job Description

We are seeking a Database Administrator / Data Engineer to support SQL Server databases, data integration, ETL processes, database performance, data validation, troubleshooting, and production database operations for an enterprise application environment.

Key Responsibilities

• Administer and support Microsoft SQL Server databases.
• Develop and optimize SQL queries and stored procedures.
• Support ETL packages and scheduled data-processing activities.
• Troubleshoot database and production data issues.
• Analyze complex data issues across integrated applications.
• Support data exchanges between enterprise systems.
• Perform data validation and reconciliation.
• Monitor and optimize database performance.
• Support database design and data-access requirements.
• Maintain database documentation and technical runbooks.
• Support data security and integrity requirements.
• Participate in root-cause analysis and knowledge-transfer activities.

Required Qualifications

• Strong Microsoft SQL Server 2019+ experience.
• Advanced SQL development.
• Experience with stored procedures, views, functions, and database troubleshooting.
• ETL/data integration experience.
• Database performance tuning.
• Data validation and reconciliation.
• Enterprise production database support.
• Experience working with application development teams and APIs.
• Experience with data security and access controls.