MS SQL Server ERwin Administrator (Jobs in MANHATTAN, NY)   Requirement id 10115 Job title Administrator Job location in Manhattan, NY Skills required Database Administrator, MS SQL Server, ERwin, Open Date 01-Jun-2012 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Administrator: Database Administrator, MS SQL Server, ERwin, [**Note : Dead Line : 6/6/2012**] [Note : Start Date : 06-11-2012 End Date : 06-30-2013] Description : Scope of Services: Lead data modeling and database design for application development and product Implementation initiatives. Participate in requirements definition, analysis and design. Create conceptual/logical/physical models for custom application development, data exchange, integration services and reporting. Work closely with business analysts, subject matter experts and development teams in Design, development, testing, implementation, and support of application projects. Facilitate creation, migration and maintenance of database objects across development/QA/production environments. Perform data model management and version control using industry standard tools like ERwin and ER/Studio. Follow best practices in data modeling including use of standard naming conventions, processes and templates to ensure consistency of data models. Monitor and optimize database performance and capacity utilization to provide high availability and redundancy. Take ownership of database performance, scalability and security. Reverse engineer and document database architecture for business-critical legacy databases. Define data strategies and architectures to meet compliance requirements. Identify and plan data replication needs between internal/external data sources and heterogeneous/ legacy platforms. Collaborate with service DBAs to optimize data structures for data integration and reporting. Define and implement data testing strategies with business stakeholders, application development teams and QA groups. Participate in the software testing process, including identification and resolution of defects. Contribute to and support roll-out strategies. Participate in and contribute to formal/informal technical reviews and presentations. Understand other database platforms like Oracle, MySQL and IBM DB2. Understand high level application architecture/design, network design, performance constraints and security frameworks. Apply technical knowledge to determine solutions and solve complex problems. Research, present and/or make recommendations on technical issues. Explore new ideas and initiatives that encourage innovation. Take inputs from reporting manager(s) and appropriately apply comments/feedback. Accurately predicts time required to complete development tasks. Demonstrate the ability to cooperate with a variety of people and achieve results. Proactively initiate, develop, and maintain effective working relationships with team members. Mentor and guide development team members on database-related tasks. MANDATORY SKILLS/EXPERIENCE Note: candidates who do not have the mandatory skills will not be considered. BA/BS Degree or equivalent, in a technology related field or other degree preferred. 8-10 years of expertise in MS-SQL Server database administration, utilities and tools. 6-8 years of application data modeling experience using tools like ERwin or ER/Studio. Microsoft Certified Database Administrator. Proficiency in supporting SQL Server 2005/2008 databases in high availability environments with intimate knowledge of both SQL and T-SQL. Demonstrated knowledge of designing, developing and integrating databases, data warehouses and multidimensional databases in MS-SQL Server. Working knowledge on cross-platform databases like MySQL/Oracle/DB2. Ability to write and optimize complex SQL queries, procedures and functions. Familiarity with BIDS (SSRS, SSAS, SSIS) and data warehousing concepts like ETL, Dimensions, Facts, Cubes. Experience with database replication techniques. Ability to perform both database-level and operating system performance tuning and monitoring.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 10115 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2),    Database Administrator job openings in other states Jobs List Database Administrator -62551 Create date: 16-Apr-2024 start date : 05/01/2024 End date :06/25/2025 submission deadline : 04/22/2024 client info : CT CTECS Note: * Position Location: Hybrid Description : Database/System Administrator Duties and Responsibilities job Jobs in CT Hartford Administrator - (in Hartford, CT)) GDOL DB2 LUW DBA DATABASE ADMINISTRATOR (728496) Create date: 31-Jan-2024 Onsite start date :02/19/2024 End date :06/30/2024 submission deadline : 02/06/2024 client info : GDOL-IT Description : In this role as a DB2 LUW DBA DATABASE ADMINISTRATOR, youll be responsible for working with the Application Develop.... (This job is for - Migration Jobs in GA Atlanta Administrator - (in Atlanta, GA)) Database Administrator 3 - 61820 Create date: 01-Dec-2023 Start date : 12/11/2023 End date :12/11/2024 Submission deadline 12/04/2023 Client info : TN DOT Note: * Position Location: Hybrid Description : Install, upgrade, patch the oracle database infrastructure. .... (This job is for - job Jobs in TN Nashville Administrator - (in Nashville, TN)) Oracle Database Administrator -61879 Create date: 29-Nov-2023 Start date : 12/17/2023 End date :12/31/2024 Submission deadline :12/08/2023 Client info : Fulton County Note: * Position Location: Hybrid Description : ORACLE DATABASE ADMINISTRATOR Overview: .... (This job is for - Jobs in GA Atlanta Administrator - (in Atlanta, GA)) ITSAC 529300551 Database Administrator 3 -SP Create date: 04-May-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000006lozAAA/529300551 Note: Online Submission Note: Total estimated hours per Candidate shall not exceed 935 hours. Note: RTR form must be signed by the candidate Submission Deadline: 5/9/20235:00 PM CT Start Date: 6/05/2023 End Da.... (This job is for - Implementation Jobs in TX Austin Administrator - (in Austin, TX))    Database Administrator job openings in NY Jobs List Senior Database Administrator - 7371 Create date: 27-Oct-2022 start date: 12/06/2022 End date: 06/06/2025 submission deadline: 11/3/2022 Note: * On-site/Remote : On-site * Interview : Phone or video call; then in-person Description: The Oracle Infrastructure team is responsible for the inst.... (This job is for - job Jobs in NY Albany Administrator - (in Albany, NY)) Junior Database Administrator - NTTJP00019592 Create date: 02-May-2019 Start Date :6/3/2019 End Date :09/02/2019 Submission Deadline:5/8/2019 Description: we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our ability to help our clients stay.... (This job is for - job Jobs in NY NewYork Administrator - (in New York, NY)) Senior SQL Server DBA - J-11-026-927 Create date: 06-Jul-2015 Note: Start Date : 08/01/2015 End Date : 07/31/2017 Submission Deadline : 07/09/2015 Client Info : COMSYS Description: Under the direction of NYC Department of Education management, major responsibilities include analysis, design, and development of systems archit.... (This job is for - job Jobs in NY BROOKLYN Administrator - (in Brooklyn, NY)) (Administrator: Database Administrator, MS SQL Server, ERwin, in Manhattan, NY)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)