Database and Report Developer

Job Description
Job Title: Database and Report Developer

Looking for a Database and Report Developer for a long term consulting assignment for an international bank in NYC.

The candidate is responsible for Database development, Report Development and some Database Admin work (as needed) using SQL and T-SQL

The candidate will be able to work independently and collaboratively with the team on the database management, development, testing, integration, maintenance, and support of the Branch on day-to-day operations.

Responsibilities:

• Responsible for all aspects of planning and management of database;
• Responsible for database environment configuration, migration and cutover, storage, fault handling, performance optimization, backup, daily monitoring, etc.;
• Design and develop database and applications with all phases of software development lifecycle.
• Use SSIS, SSRS, and SQL to develop ETL packages and reports.
• Design and develop new features/functionalities of ETL Data Integration using SSIS, SQL, C , Java, Python, etc.
• Perform hands-on data-related tasks such as data analysis, data integration, data issue remediation, data reconciliation, data warehousing, and reporting automation.
• Develop functions, views and stored procedures, complex SQL queries for reports that meet business requirements.
• Write technical documents and testing reports. Provide support for the internal and external audit and exam.
• Be responsible for demonstrating risk awareness by following all policies, procedures, and internal control in their daily routine.

Education and Experience Requirements:

• Bachelor's degree in Computer Science or equivalent related field.
• 3-5 years of experience in Microsoft SQL Server or other database applications in an enterprise environment.
• some DBA experience is a plus. Fluent in both English and Mandarin is strongly desired.

Skills and Knowledge Requirements:

• More than two years ofDBA related work experience. Have experience in large-scale database operation and maintenance management.
• Familiar with data backup, restoration, import, export, synchronization, format conversion and other operations of Microsoft SQL Server or other database.
• Extensive experience writing advanced SQL queries and stored procedures and troubleshooting their performance.
• Experience in develop test plans, test scripts, validation procedures, and perform system testing.
• Familiarity with Business Intelligence tools including SSIS and SSRS, integration with SQL.
• Ability to develop reports development and maintenance policies, and draft the new product or report requirements.