Client location: NYC, USA
If you are interested to work in NYC, USA, Please go through requirement details & email your latest resume.
Along with your resume please include following details:
1. Contact number:
2. Location:
3. Ready to relocate:
4. Your availability:
5. Visa Status/Citizen:
Job Description:
Job Title Database Analyst/Technical DBA
City NYC, USA
Duration Full-Time
Contract Type Permanent
Job Description/Skills Required: Role: Database Analyst/Technical DBA
==========================================================
POSITION OVERVIEW:
Expertise in Database Analysis of Microsoft SQL databases is a requirement of this position. Responsibilities will encompass an enterprise wide scope in terms of managing, defining and controlling corporate data assets and providing support for data access, data definition and data management. This role will include data modeling, data definition and data access services. Desirable talents include the ability to work with business analysts to develop and execute data migration plans, institute and administer data management procedures and support and rectify daily operational production issues. Expertise in mentoring and working with the other DBAs in the group in both the technology and use of internal tools and data trends. Other duties will include working with other groups in the organization to define data architecture.
Required Skills:
Minimum of 4 years of data architecture and BI integration experience.
Extensive knowledge of MS SQL Server 2000/2005/2008.
Expertise in designing and creating complex SSIS based programs.
Expertise in C# scripting focused on data manipulation and transformation.
Technical knowledge of MS SQL Server internals with emphasis on query performance on
Experience defining & maintaining Data Naming and Data Definition Standards Create & Maintain Conceptual & Logical Data Models on Data Project
ESSENTIAL DUTIES & RESPONSIBLILITIES:
Interact with and coach developers in SQL scripting and database schema.
Create and debug stored procedures in cooperation with application developers
Define, recommend appropriate Data Sources on Data Projects.
Define & maintain Data Naming and Data Definition Standards.
Create & Maintain Conceptual & Logical Data Models on Data Projects.
Enforce and support HarperCollins published data promotion standards.
Create and debug views and SQL functions to support data and application access.
Work with the Physical DBA to create & manage physical databases.
Work with the Physical DBA to address data performance and data consistency problems
Adhere to corporate ethics policies with regards to confidentiality of information.
Contribute to departmental performance by completing other related duties as assigned.
EDUCATION AND EXPERIENCE:
Competent to work at the highest technical level of all phases of data management activities.
Strong problem solving and analytical skills.
Four or more years of database administration (DBA with SQL 2000/2005/2008).
2 + years practical experience constructing SSIS and in data modeling techniques including data normalization, conceptual, logical and physical database design
Demonstrated proficiency with SQL DB programming and design
Strong understanding of OLAP, Datasets, Installing/Designing and Tuning Database Software/Infrastructure, and browser-based programming.
Good working knowledge of Microsoft SQL Server (2008 preferred)
Requires a bachelors degree with emphasis in computer science, or management or equivalent level of experience.
Regards,
No comments:
Post a Comment