| Job ID: | Job-0704 | | Job Title: | SQL Server DBA | | location: | New York City | | Jobtype: | Permanent | | Rate: | $110K - $120K +bonus | | Primary Skills: | SQL Server DBA, Erwin, clustering | | Description: | Provide database administration support to sqlserver databases.
Review and assess impact on requests for enhancements to applications from a data perspective.
Create and maintain Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
Review database patches provided by vendors and implement, test and deploy them as needed.
Support development and enhancements to both logical & physical database models.
Review stored procedures and SQL queries developed by the development staff for performance & Provide appropriate guidance to fine-tune the objects.
Develop & maintain ERD diagrams, data dictionaries and metadata repositories using tools like ERWIN.
Developing and maintaining backup/recovery methods and disaster recovery procedures.
Oversee Lifecycle Management of database servers.
Plan, configure, Install and maintain Database monitoring tools.
Prepare and update capacity plans based on performance analysis and statistical data collection.
Keep current with technology, IT best practices and data warehousing trends in order to make appropriate development recommendations.
Understanding of how to translate business rules and data requirements into database designs is desired.
Experienced in installing & maintaining Data warehouse using both Relational and Dimensional Models
Comply with proper internal controls as necessary to conduct job functions and/or carry out responsibilities and/or administrative activities at Company.
Other Job Functions: Database administration including fine-tuning and backup-restore.
Both Logical & Physical database design
Review and fine-tune SQL code
Review query plans to assess performance and fine-tune tables & queries as necessary.
Participate in solution data architecture and impact analysis
Monitor Production databases to ensure high-availability and performance that meets Business expectation.
Perform special projects and other duties as may be assigned.
Regular and reliable attendance.
Qualifications: At least a 4 year college degree in computer science or related field.
At least 5 years of experience in working with SQL Server.
Strong database design concepts. Use of ERWIN required for modeling
Experience implementing Database clustering, mirroring and data replication
Experienced in installing and maintaining both relational and dimensional datawarehouse.
Administration Knowledge of Oracle is a plus
Working knowledge of Informatica tool & Cognos is a plus.
Knowledge of ACORD XML messages is a plus.
Experience working in P & C companies is desirable. Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume. NO RELOCATION. NO VISA TRANSFERS. NO OVERSEAS RESUMES. NO 3RD PARTIES. To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe. Receive tweets from Twitter with job search tips and job listings – TheBigGameHuntr | |
<< Home