Address
Form of workJob Description
***We are unable to sponsor for this permanent full-time role***
***Position is bonus eligible***
Prestigious Firm is currently seeking a SQL DBA with SSIS experience. Candidate will be responsible for providing operational support of project initiatives and will play an integral role in the maintenance, support and enhancements of business critical applications.
Responsibilities:
- Optimize stored procedures, functions and ad-hoc SQL.
- Design, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systems.
- Implement, create reports and provide general support for SQL Server Reporting services.
- Monitor relational databases to optimize performance, resource use, backup/recovery, and physical implementation.
- Review database objects and create and maintain change controls.
- Monitor and maintain database security.
- Migrate databases between servers and various platforms.
- Analyze and resolve SQL Server faults.
- Document data flows, application specifications from a DB perspective and system procedures.
- Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping.
- Support highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers).
- Investigate and resolve reported application issues, escalating issues as necessary to the application owners.
- Provide 24x7 on-call support on a rotating basis.
- Flexible to work off-hours, as required.
Qualifications:
- Bachelor’s degree in Computer Science or a related field or related experience.
- A minimum of 5 years of experience with SQL.
- Expert with SQL Server performance management and tuning, including identifying solutions that optimize SQL execution plans.
SQL Server Administration experience including:
- Triggers.
- Stored Procedure Code Development and Standardization.
- Data Integration and Migration.
- Management Studio.
- SQL XML.
- Database Auditing and Controls.
