Ms sql dba with 7yrs exp - mcdba, mcts certified
Resume:
Jayakumar Krishnan
916-***-**** || *****************.***@*******.***
Professional Experience Summary
• 7+ Yrs experience in MS SQL DBA profession and 10+yrs total IT experience.
• Experience in administering MS SQL 7.0/2000/2005/2008 and Oracle 9i/8i Server.
• Excellent experience in installation, configuration, database design (logical/physical).
• Experience in disaster recovery, performance tuning, and migration from 2000 to 2005.
• Experience in replication, log shipping setup and mirroring setup and troubleshooting.
• Experience in installing MS SQL multiple instances in windows cluster environment.
• Experience in MS SQL security management.
• Maintained over 3000 productions and pre-production and UAT servers and high availability (HA) of 24x7 production servers.
• Setting up SQL 2005 Dashboard reports for centralized monitoring.
• Experience in handling 4.5TB databases.
• Experience in installing multiple instances of SQL failover cluster on SQL 2005 & 2008.
• Handling multiple instances in failover cluster (Active/Active/Active/Passive) for SQL 2005 on Windows 2003 on SAN.
• Handling multiple instances failover cluster (Active/Passive) for SQL 2008 on Windows 2008 on SAN.
• Experience in using Dynamic management views for Database health monitoring.
• Experience in working with Microsoft global clients and customers and handling high priority production issues over Email/phone.
• Managing projects within the Software Development Life Cycle (SDLC) and Project Planning and Implementation phase on all aspects of the engagement.
• Worked as Tier 3 level DB Engineer and Troubleshooting customer escalations and providing solutions to Tier 1 and Tier 2 DB support team.
• Working and providing solutions on customer escalations
• Coordinating with business users for UAT and client acceptance for bug fixes in production environment
• Working with Microsoft global customers and handling priority customer issues through SOC and worked with MSE.
• Experience in working with Incident and problem management tickets.
• Experience in assigning & reviewing tasks and imparting training & technical guidance to team members.
• Experience in providing database support for various escalations from different regions.
• Building and configuring production servers and installing the application, patches and fixes.
• Installed Service Packs & IPAKs (Service Pack with Hot fix) and MS SQL 2005.
• Handled Mission Critical servers including Microsoft’s customer and revenue data servers.
• Designed the entire logical and physical model using Visio, ERWin.
• Experience in writing procedures, functions and triggers.
• Experience in writing batch scripts.
• Experience in Troubleshooting and resolving databases and server issues.
• Experience with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).
• Experience in migration from SQL 2000 to SQL 2005.
• Experience in working, supporting and troubleshooting IIS related issues hosted in NLB clusters.
• Experience in Configuring, Maintaining and Troubleshooting website related issues.
• Experience in TCP/IP, DNS and connectivity issues.
• Experience in IIS & Web Server.
• Experience in Active Directory in Windows Servers.
• Experience in SAN and Networking.
• Experience in writing batch scripts on command line base.
Certifications:
MCTS Microsoft Certified Technology Specialist in SQL Server 2005.
MCDBA Microsoft Certified Database Administrator
OCA Oracle Certified Associate - Oracle 9i
RDBMS Concepts - Brainbench Certified (Transcript Id: 5814312)
MS SQL Server 2000 Programming - Brainbench Certified (Transcript Id: 5814312)
Education: Master in Computer Application, Madurai Kamaraj University, Madurai, India.
Skills / Tools:
Databases: MS SQL Server 7.0/2000/2005 & 2008, Oracle 8i/9i, MS Access, Foxpro 2.6, Clipper
SQL Server 2000 Tools: Enterprise Manager, DTS, Query Analyzer, Client Network Utility, Server Network Utility, Profiler, Index Tuning Wizard
SQL Server 2005 & 2008 Tools: Query Editor, SQL Profiler, Database Engine Tuning Advisor, SSMS, SSIS, SSAS, SSRS, SSCM, SQL Server Surface Area Configuration.
SQL Server Third Party Tools: Veritas 4.5, 5.0 and Quest SQL Lite Speed 4.7, Erwin.
Reporting tools: Crystal report 8.5/7.0, Cognos 7.0 PowerPlay
Programming Languages: SQL, PL/SQL, T-SQL, HTML, VBScript, VB 6.0.
Front End Tools: MS Office 2000/2003/2007, MS Visio, MS Project, Business Objects.
Servers: Windows Computer Cluster Server, Microsoft Virtual Server, VM Ware
Operating Systems: MS Windows Server 2000/2003/2008 Standard/Enterprise Edition, Windows NT 4.0 Work Station/ Enterprise Edition, Windows XP Professional, HP Unix (DBA Level)
Professional Experience:
Microsoft
Sr.SQL Server DBA
June 2008 to Till Date.
• Working with 400+ servers for MS AdCenter Production/Sandbox and Pre-Production Environment.
• Supporting mission critical 3+ TB databases
• Installing SQL 2005/2008 in Production & Pre-Prod environement.
• Applying database patches in all the environments.
• Automated bugs/white list apply in all Prod/Sandbox and Pre-Prod environment using DOS batch script with PsExec and Robocopy utilities.
• Handling multiple instances failover cluster (A/A/A/P) for SQL 2005 on Windows 2003 on SAN.
• Handling multiple instances failover cluster (A/P) for SQL 2008 on Windows 2008 on SAN.
• Monitoring databases health through Dynamic management views.
• Planned Disaster recovery with SQL 2008 Compression feature.
• Coordinating with Dev team and fixing issues on production.
• Handling on DTS/SSIS Packages.
• Handling Reporting services (SSRS) Configuration and deployment on Production environment.
• Deployed SSRS Dashboard reports for DB monitoring.
• Handling DB Security issues like adding, removing NT logins & creating new SQL users in PROD and Pre-Prod environment.
• Installed & Configured database backups using SQL LiteSpeed 4.6,4.7,4.8.
• Setting up Log shipping & Replication on Production environment.
• Rebuilding Indexes, Update statistics on weekly basis.
• Setting up SQL 2005 Dashboard reports for centralized monitoring.
• Creating ETL packages in SSIS 2005 that transfer data between servers and perform other data transformations
• Migrated Databases from SQL 2000 to SQL 2005.
• Created SSIS 2005 packages that will populate data in data warehouse tables.
• Writing batch scripts on command line based using SQLCmd for executing sql files on different instances & remotely stops and starts specific services.
• Working with IIS and Web server for IIS reset on need basis.
• Supporting the build deployment in production and test environments
• Automated tools for moving files between cross domains using batch scripts.
• Setup Mirroring in cross data centers with transactional replication successfully.
Environment: MS SQL 2000, 2005 & 2008 Servers, SQL Cluster Servers, MS Windows Server 2003 & 2008 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS, SSRS, SSAS, SSMS, DBCC, Quest SQL Lite Speed 4.6/4.7 & 4.8, Cluster environment: 4 nodes (Active/Active/Active/Passive) and 3 nodes (Active/Active/Passive) cluster with SAN environment.
The Centre to Promote Healthcare Access, Sacramento, CA.
Senior SQL DBA
February 2008 to May 2008.
• Objects moving between Development, Staging, Pre Production and Production.
• Writing Stored Procedures & Functions based upon request.
• Created new user databases, database files, database files groups in SQL Server 2005 via SSMS and T-SQL.
• Upgraded SQL Server 2000 Enterprise Edition to SQL Server 2005 Enterprise Edition.
• Maintaining existing SQL Server 2000 installations and new SQL Server 2005 installations on SAN.
• Handling multiple instances failover cluster (A/P) for SQL 2005 on Windows 2003 on SAN.
• Monitoring databases health through Dynamic management views.
• Granted, updated and revoked privileges to database users on database objects in SQL Server 2005.
• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2005.
• Designed the entire logical and physical model with 100 + tables using Visio, ERWin.
• Enforced referential integrity via creation of constraints on database objects.
• Populated user databases in SQL Server 2000 via DTS utility.
• Worked on DTS Packages, DTS Import/Export for Transferring data from Heterogeneous Databases.
• Migrated Databases from SQL 2000 to SQL 2005.
• Configured database backups via Full, Differential and Transactional Log database backup in Maintenance Plan both in MS SQL 2000 and 2005.
• Scheduled backups configured database mail profiles for sending automatic mails to respective users upon failure of a database task.
• Configured and worked on log shipping, database snapshots and database mirroring.
• Created SQL Server traces using SQL Server Profiler for optimal performance monitoring.
• Creating MDX queries.
• Creating ETL tools for transforming data to/from in flat files using SSIS.
• Created Database Maintenance Plans for Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Adding Users in Active Directory.
• Resetting IIS based on request.
• Maintained SQL Script for creation of Database Objects.
Environment: MS SQL 2000 & 2005 Servers, SQL Cluster Servers, MS Windows Server 2003 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, SSMS, DBCC, Quest SQL Lite Speed 4.6, ERWin, MS Visio, Cluster environment: 2 nodes (Active/Passive) cluster with SAN environment.
HP, Chennai, India.
Senior SQL DBA
October 2006 – December 2007.
• Installed and configured SQL Server 2000/2005 Enterprise Edition.
• Created new user databases, database files, database files groups in SQL Server 2005 via SSMS and T-SQL.
• Upgraded SQL Server 2000 Enterprise Edition to SQL Server 2005 Enterprise Edition.
• Maintained all existing SQL Server 2000 & 2005 databases and new SQL Server 2005 installations.
• Granted, updated and revoked privileges to database users on database objects in SQL Server 2005.
• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2005.
• Handling multiple instances failover cluster (A/A/P) for SQL 2000/2005 on Windows 2003 on SAN.
• Monitoring databases health through Dynamic management views.
• Enforced referential integrity via creation of constraints on database objects.
• Created SSIS packages via SSIS for transfer of database objects from SQL Server 2000 databases to SQL Server 2005 databases.
• Populated user databases in SQL Server 2000 via DTS and BCP command line utility.
• Worked on DTS Packages, DTS Import/Export for Transferring data from Heterogeneous Databases.
• Configured database backups via Full, Differential and Transactional Log database backup in Veritas backup tool.
• Scheduled backups in Unix Server and configured database mail profiles for sending automatic mails to respective users upon success or failure of a database task.
• Configured and worked on database replication, log shipping, database snapshots and database mirroring.
• Monitored lock Escalation, Dead Locks, resources utilization by sessions, capturing long running SQL queries.
• Created SQL Server traces using SQL Server Profiler for optimal performance monitoring.
• Created Database Maintenance Plans for Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained SQL Script for creation of Database Objects.
• Created stored procedures for maintaining SQL Server.
• Oracle – Standby Management – Checked Primary and secondary databases Sync.
• Oracle – Backup Scheduling, Backup and Recovery using RMan.
• Involved in Handling Top and High Priority issues and handled Escalations and customers.
• Coordinated with multiple support teams and complete request as per SLA.
• Oracle – Added Data files if needed
Environment: MS SQL 2005/2000 Servers, SQL Cluster Servers, MS Windows Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS, SSRS, SSAS, SSMS, Oracle 8i/9i, HP Unix Server DBCC, RMan, Veritas 4.5/5.0. Cluster environment: 2 nodes (Active/Passive) cluster with SAN environment.
Microsoft GDIC, Hydrebad, India (Wipro Technologies)
SQL DBA - Level 2
January 2006 – September 2006
• Maintained over 3000 productions and pre-production servers 24x7 in MS SQL Server 2000 and 2005 Beta & Yukon RTM environments worldwide.
• Improved and maintained high availability (HA) of 24x7 production servers with disaster recovery management, which includes replication, log shipping, Mirroring and clustering.
• Installed, configured and maintained MS SQL 2005/2000 Servers and MS SQL Clustered Servers.
• Installed Service Packs & IPAKs (Service Pack with Hot fix) and MS SQL 2005 Analysis and Reporting services.
• Handling multiple instances failover SQL cluster (A/P) for SQL 2000/2005 on Windows 2003
• Handling multiple instances failover SQL cluster (A/A/P) for SQL 2005 on Windows 2003
• Installed and configured SQL LiteSpeed, a third party tool for SQL server backup and recovery.
• Populated databases in SQL Server 7.0/2000 & 2005 through DTS, BCP and SSIS. (SQL Server Integration Services)
• Troubleshoot and resolved database and server issues.
• Handled Data file and Log file critical issues.
• Handled Mission Critical servers including Microsoft’s customer and revenue data servers.
• Set up and maintained Log shipping, replication and SQL cluster servers
• Troubleshoot on replication, Log shipping and SQL clustering issues.
• Involved in System Performance monitoring and tuning.
• Performed database maintenance tasks using DBCC.
• Involved in data migration and conversion using Data Transformation Services (DTS) and BCP.
• Established Database Mirroring in SQL 2005 on Production Environment
Environment: MS SQL 2005/2000 Servers, SQL Cluster Servers, MS Windows Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS, SSMS, DBCC, Quest SQL Lite Speed 4.0 Cluster environment: 2 nodes (Active/Passive) cluster with SAN environment.
YRG CARE, Chennai, India.
MS SQL 2000 Database Administrator
May 2003 – December 2005
• Designed, implemented, and administrated databases in SQL Server 2000.
• Maintained databases, configured permissions, and conducted backup and recovery.
• Used DTS tool to transfer data to SPSS analysis tool.
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL.
• Performed daily administration, monitoring, and documentation of SQL Servers.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Designed the entire logical and physical model using ERWin.
• Created alerts and notifications for system errors, insufficient resources and fatal database errors.
• Used SQL Profiler and Performance Monitor for troubleshooting, monitoring, tuning of SQL Server and SQL code.
• Exported data from Oracle 8i to MS SQL 2000.
• Generated analysis reports using Cognos 7.0 PowerPlay
• Created Entity Relationship Diagrams (ERD) to successfully design a flexible database. Maintaining online documentations for entire source code
• Developed and implemented a database maintenance plan encompassing integrity checks, updating statistics, security and hardware resource utilization.
• Established regular backups of databases and transaction logs.
• Created Analysis reports in Crystal Reports in 7.0,8.5
• Designed & Created applications in VB 6.0
• Designed and Integrated Crystal reports with VB applications.
• Performed scheduled data uploads to database using nested queries and joins.
• Scheduled and managed jobs for data transfer using DTS packages.
• Installed, maintained and upgraded application software tools, on servers and client computers.
• Allocated system storage and participated in planning for future storage requirements.
• Applied relevant maintenance patches to respective applications.
Environment: MS SQL 7.0/2000 Server, MS Windows Server 2000 Enterprise Edition, Query Analyzer, SQL Profiler, SSEM, Oracle 8i, Crystal Reports 7.0, 8.5, VB 6.0,
Consolidated Cybernetics Co. Pvt. Ltd, Coimbatore, India
Senior Software Engineer
November 2000 – April 2003
• Designed, implemented, and administrated databases in SQL Server 2000.
• Involved in database design (Logical and Physical).
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL in MS SQL 2000 and Oracle 8i.
• Performed daily administration, monitoring, and documentation of SQL Servers.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Installed, maintained and upgraded application software tools, on servers and client computers.
• Wrote code and creating jobs to automate repetitive tasks.
• Performed Application implementation on Client site.
• Did Visual Basic Programming and Report Designing in Crystal Reports 7.0
• Handled End user Training and software maintenance.
• Participated as Exhibitor, HOSPI MEDICA – ASIA (International Healthcare industry Exhibition.) on Sep - 2002 at Suntec city, Singapore.
Environment: MS SQL 7.0/2000 Servers, Windows 2000/NT servers, Oracle 8i, Crystal Reports 7.0, Visual Basic 6.0.
Sheela Hospitals Pvt. Ltd, Coimbatore, India
Software Engineer
August 1998 – October 2000
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL in MS SQL 7.0 and Oracle 8.
• Writing code and creating jobs to automate repetitive tasks.
• Designed and Developed applications in VB 6.0 and Foxpro 2.6
• Involved in User Interaction, Requirement Analysis.
• Involved in Visual Basic Programming and Report Designing in Crystal Reports 7.0
• Performed daily administration, monitoring, and documentation of SQL Servers.
Environment: MS SQL 7.0, Oracle 8, Crystal Reports 7.0, VB 6.0, Foxpro 2.6
Contact this candidate