Available SQL Server DBA
pavan Groups
Name: Shyam
Rate: 65/hr on C2C
- Around 9 years of experience as a SQL Server DBA and development performed with DBA duties all in enterprise environments
- Extensive working experience in various industries including banking, financial, marketing services, and healthcare industry.
· Experience in an operational environment providing support, involving coordination with release Management, Ticketing System and Change management.
· Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
· Supported Upgrades of CRM versions and extensively worked on Procedures and Purge tasks of CRM databases.
- Experience with Software Development Life Cycle (SDLC), Microsoft Operations Framework (MOF) and project management methodologies.
- Extensively worked with Middle vendors to troubleshoot issues, co-ordinate with developers at the time of release.
- Experience with SQL Server 2000, SQL Server 2005, SQL Server 2008 installation, administration and management of multiple instances/servers in highly transactional environments
· Hands on experience in making SOX compliance reports and maintain them for each quarter.
· Hands on experience on TFS ( Team Foundation Server ) , Red Gate tools and Release Management
· Worked with APP, DBA and Developers team on SSIS, Upgrade’s and Automation Procedures for various requirements.
· Hands on experience on tools like Actifio , NetBackUp , SQL Idera and VS 2010/2012 .
- Experience with VLDB databases of size nearly 1TB on multiple instances.
- Experience with Migrations from SQL 2000/2005 to SQL Server 2008 and SQL 2012
- Familiar with SQL 2012 new features and hands on experience “Always On”
- Worked on Server Migrations (hardware), Data center migrations, Version upgrades.
- Worked on SQL 2008 features like data compression, backup compression etc
- Worked on various SSIS/DTS packages for data import/export/transformations from different OLEDB/Flat source to SQL 2005/SQL 2008
· Extensively worked and had good knowledge on Integration and Reporting Services(SSIS and SSRS) and good experience in Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
· Proficient in physical database design, and SQL Performance tuning, DR solutions.
· Used tools like Sonasafe, SQL LiteSpeed and SQL Server backup v9 and Netbackup client for backing up databases.
· Experience in backup and disaster recovery procedures like log shipping and high availability solutions like clustering, database mirroring
· Experience in Replication – Snapshot, Merge and Transactional.
- Hands-on working experience with analyzing query plans, query optimization, performance tuning, managing indexes and locks, troubleshooting deadlocks.
· Proactive monitoring with SQL Alerts, Jobs, and DBA related scripts & Reports
· Involved in OLAP schema design, cube development, data warehousing design, MDX, optimization, and front-end implementation and development.
· Worked on Visual Studios 2010 Ultimate version to build solutions and check in the changes to TFS Server.
· Proficient with tools like BIDS,SQL Profiler, DTA, DMVs, Perfmon, IDERA Diagnostic Manager, Performance Dashboard etc
· Excellent communication skills. Proactive, independent and easy-going
Education
Bachelor of technology from JNTU, India
MSEE from Fairleigh Dickinson University, NJ - 07666
Certifications
· MCTS: Microsoft SQL Server 2008, Implementation and Maintenance.
· MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.
Thanks & Regards,
Pavann
Sr IT Recruiter
Mail: pav...@compuga.com
Direct: 619-353-1695
Gtalk & YID: pavankumarrec