What are the responsibilities and job description for the Database and Report Developer (Mandarin) position at International Bank?
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 of DBA related work experience. Have experience in largescale 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.
Job Type: Contract
Pay: $64.34 - $67.98 per hour
Schedule:
- 8 hour shift
Experience:
- SQL: 2 years (Required)
- Database administration: 2 years (Required)
Language:
- Mandarin (Required)
Work Location: In person
Salary : $64 - $68
