URGENT Req:: SQL DBA( Locals only ) - Irving, TX

Hi Partner,

Hope you are doing great!

Please respond with Resume, Rate and Phone numbers of the consultant to: prasad@cigniti.com ASAP.

 

Position : SQL DBA( Locals only )

Location: Irving, TX

Duration: 6+ months contract

 

SQL DBA for an open position in Irving, TX.

 

The person is responsible for handling the following day-to-day activities which are essential to deliver metrics on a timely basis and ensuring the validity of the same to satisfy highly demanding business needs.

• Round the clock monitoring of Jobs that are running in production and taking necessary action when there are issues.
• Implementation of Production Changes during the scheduled days and providing post-production support
• IR Handling for all data marts - ensuring that all assigned IRs are attended and resolved to customer satisfaction in a timely manner
• Analyzing and performance tuning of daily running jobs in production. Re-design & develop the jobs when there is a better way of getting the things done.
• Informatica applications configuration, setup, applying HotFixes and administration
• Hourly communicating to business users about ETA for metrics delivery on a daily basis.
• Handling of adhoc reporting and feed requests from production and ensuring to provide monthly and quarterly feeds to finance and Internal audit teams
• Checking on any long running production jobs and doing any performance tuning activities to ensure jobs are moving faster.
• Cleaning up unwanted/decommissioned SQL Server Analysis Services databases
• Monitoring DB backup, restore and cleanup of Logs
• Ensuring all inbound feeds are received and data is loaded properly
• Ensure that all metrics data loads are done for the right date and time
• Ensuring all outbound feeds are sent on-time and accurately
• Taking daily backups of Shell scripts and Informatica repository
• Cleaning up of Old Logs and ensuring all UNIX file systems has enough space to handle daily jobs.
• Gathering source system maintenance/downtimes during weekends and informing to business about metrics impact
• Ensuring on-time delivery of metrics
• Verifying and making sure that Microsoft Analysis services cubes are processed properly and reports are published properly in the reporting environment
• Page/email source System support when there is any delay/issue with files/Database
• Working with Database Administrators for any DB related issues
• Analyzing problems, determining root cause, reporting on problem status, etc., for network and desktop (application hardware and software) issues
• Activities associated with incident analysis, resolution and tracking, problem-related task forces, developing and running of utilities and recoveries
• All the System generated tickets will be paged to on-call support and the same need to be resolved immediately

Required Skill Sets: 

•  Masters degree with 7+ years of professional experience working in building DataWarehouse Applications
• 7+ years of development experience with a minimum of 5 years in Data Warehousing and Business Intelligence
• 7+ years of strong experience in Analysis, Design, Development, Testing and deployment of ETL jobs
• 7+ years of strong experience using Oracle SQL and PL/SQL.
• 5+ years of experience with UNIX shell scripting(Ksh/Csh)
• 5+ years of Informatica PowerCenter 9.x/8.x/7.x/6.x experience
• Experience in Informatica PowerCenter Installation, upgrades and applying HotFixes.
• Experience in complete life cycle implementation of an Enterprise Data Warehouse
• Good understanding of Ralph Kimball Data Warehouse methodologies and knowledge on the various data design models like Star schema and Snowflake models
• Exceptional analytical and problem solving skills. Team player with the ability to communicate effectively at all levels of development process
• Experience in Oracle development and performance tuning related to large data volume
• 3+ years of experience in Production Support and code migration from different environments to Production

Desired/Nice to have Skill set (in addition to the Required Sill Set mentioned above):

• Microsoft SQL server, Analysis Services(Cubes), Integration Services & reporting services experience
• Working experience in Telecom Data Warehouse
• Experience in SharePoint excel services
• Working experience with scheduling tools like Appworx, Tidal Enterprise Scheduler.

 

 

 

Thanks & Regards,

 

Prasad Mamidela| Technical Recruiter | Cigniti, Inc ®

Ph:  W: 972-756-0622 Ext 132 | F: 972.767.0948

Email: prasad@cigniti.com | www.cigniti.com

IM: prasad_cigniti

 http://in.linkedin.com/in/prasadmamidela

433 E Las Colinas Blvd. # 1240 Irving TX 75039

 

 

 

P Save trees. Print Only When Necessary