Database Adminstrator - 1215
Universal Technologies, LLC - New York, NY

This job posting is no longer available on Universal Technologies, LLC. Find similar jobs: Database Adminstrator jobs - Universal Technologies jobs

Our client needs a Database Administrator/Application Data Modeler/SQL Developer who has expertise in data modeling, logical/physical database design, SQL/T-SQL development, performance tuning, database monitoring, maintenance, and hands-on database development experience with Microsoft SQL Server 2008/2012, Reporting/Integration/Business Intelligence (BI) Services, to lead database design and management for NYCStreets Permit Management System Program. Candidates with additional experience in cross-platform databases like MySQL/ Oracle/ DB2 and with a strong application development background are preferred for this position.

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.
Develop, review and optimize SQL/T-SQL code.
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

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 or equivalent certification in database development and management
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.
Knowledge of SQL Server backup and recovery scenarios.
Proficiency in SQL Server security management.
Experience in code migration, database change management and data management through
the various stages of the development life cycle.
Ability to design databases according to industry standards and make tuning
recommendations.
Strong analytical, decision-making and problem solving skills.
Good communication, presentation and leadership skills.
Team player who can establish excellent working relationships with peers and other teams.
Ability to work on multiple projects as team lead or team member.
Ability to understand business requirements and estimate for delivery commitments.
Utilize application development environments, tools and methodologies across multiple
platforms.
Experience using Microsoft Office Applications.

DESIRABLE SKILLS/EXPERIENCE

Technically proficient in more than one language and platform.
Familiarity with Open Source database initiatives.
Experience in replication between Mainframe systems and relational databases.
Experiences with database-level encryption technologies.
Experience with high availability features such as clustering and mirroring.
Prior experience with database server installations and configurations.
Strong object-oriented analysis, design and programming skills.
Expertise in Microsoft .NET web application development.
Experience involving all phases of the Software Development Lifecycle.
Experience with version control and release management principles.
Prior experience in federal/state/local government projects.

UNIVERSAL Technologies is an Equal Opportunity Employer.

Universal Technologies, LLC - 16 months ago - save job - block
Recommended Jobs
Research Grants Adminstrator
American Foundation for Suicide Prevention - New York, NY
OpportunityKnocks.org - 9 days ago

Sr. Associate Systems Administrator / Data Sc...
KPMG - Woodcliff Lake, NJ
KPMG LLP - 30+ days ago

Production Support eCommerce Websphere Admin
Randstad Technologies - Secaucus, NJ
Randstad Technologies - 30+ days ago