SQL Server DBA
Resume:
Venkata Krishna Musunoori **** John Penn Circle
***************@*******.*** Charlotte, NC 28215
SQL Server DBA
Summary
Four years of IT experience in MS SQL Server 2008, 2005, 2000 in Production, Test, QA, Development Environments.
Expert in Installation, Maintenance, Configuration and Administrating of MS SQL Server 2008, 2005 and 2000 in clustered and stand alone servers.
Experience in Upgrading MS SQL Server 2000 to 2005 and MS SQL Server 2005 to 2008 and applied service packs and hot fixes and Unattended Installations.
Good knowledge of Relational Database Management Systems (RDBMS).
Experience in Data Modeling, Database Design, Database Programming and ETL Development.
Expert in performing the administrative functions including Backup (FULL, T-LOG, DIFFRENTIAL) and Recovery of database, Database security, Running Database Consistency Checks, Designing and Optimization.
Extraction Transformations and Loading (ETL) using DTS and Microsoft SQL Server 2005 Integration Services (SSIS) and BCP.
Experience in solving various Data Warehouse issues found while migrating from DTS to SSIS.
Assisted developers to write SSIS packages according to the business requirements.
Extensive Experience in Performance tuning.
Experience in monitoring tools such as SQL Profiler, Perform and Configuration Manager.
Good experience working with various operating systems like MS Windows Server 2000, 2003 and 2008.
Experience in working and installing Microsoft Clustering Services (MSCS) MS SQL Server 2008/2005 Active/Active on window 2008, 2003.
Very good experience in Database Mirroring as Disaster Recovery plan in MS SQL Server 2008/2005.
Implemented different types of Replication models like Snapshot and Transactional.
Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008 databases.
Created complex T-SQL Stored Procedures, triggers, cursors, Index, views and other statements for applications.
Experience in writing T-SQL Scripts and Batch files.
Extensive experience in Capacity planning, Performance Tuning, and troubleshooting.
Good experience of working with VLDB’s.
Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
Expert in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS utilities.
Good experience in resolving blocking and Dead lock issues.
Extensive experience in Creating, Building, Deploying various Data and Control Flow tasks using SSIS.
Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
Education:
Masters in Computer Science, Silicon Valley University, California
B.S. in Computer Science, Jawaharlal Nehru Technological University, India
Good Application Experience in
Administration and Installing of MS SQL Server 2008, 2005, 2000.
Upgrading MS SQL Server 2000 to 2005 and MS SQL Server 2005 to 2008.
Database Designing and Security.
DTS (Data transformation services), SSIS (SQL Server Integration Services).
Experience with writing SQL Scripts and batch files.
Good hands on experience with T-SQL.
TECHNICAL SKILLS
Languages C, T-SQL, Pl/SQL, Power Shell
Web Technologies HTML, DHTML, ASP.Net, XML
OLAP Tools MS OLAP Services Manager
Version Control Tools Visual Source Safe, Rational Clear Case
Web Server Technologies IIS 5.1/6.0/7.0
Reporting Tools Microsoft SQL Reporting services
(SSRS) 2008/2005
Modeling Tool CA ERWIN 3.5/4.0, Microsoft Visio 2002
Operating Systems Windows 2000/2003 Advanced Server, Windows Exchange Server 2003
Windows NT 4.0/3.5, Windows9.x, Windows XP , Unix , Linux
Performance Tools Idera Diagnostic Manager, Quest spotlight
Backup Tools Quest Light Speed, Idera SQL safe backup, RedGate Backup
Log Tools Lumigent Log Explorer, Red Gate log rescue tool
Hardware EMC DMX & IBM Fast T 700 Storage Area Network (SAN), HP
ProLiant DL380 G4, IBM Pseries, Compaq Proliant 8000, 6500, 6000, Dell Poweredge Servers.
Professional Experience
Duke Energy, Charlotte, NC May,2011 - Dec 2011
SQL Server DBA
Responsibility includes configuring, administration and troubleshooting multiple databases in development, QA and Production environments.
Successfully Upgraded from SQL Server 2000 to SQL Server 2005 on Testing, Development and Production Environment.
Generated test data and check databases consistency to meet the functionalities requirements.
Involved in Data Modeling and Designing
Created jobs, alerts, activity logs, error logs to capture any possible errors
Configured MS SQL Server 2005 in-built Mirroring as a Disaster Recovery.
Configured Various Replication Types between Primary Server and Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2000/2005/2008 Environment to Test the Software.
Installing applications and establish the connectivity with the database.
Creating Stored Procedures to convert database tables into XML format and display via web.
Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS Packages.
Experience migrating DTS packages to SSIS manually for custom legacy systems.
Assist ETL Developers to write and debug SSIS packages.
Performance tuning, and optimization of procedures and queries.
Worked with SQL Server Profiler to generate traces.
Used Diagnostic Manager from Idera solutions for Pro Active monitoring SQL Servers.
Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
Used Notification Services Available In SQL Server 2005 to create alerts and email notification.
Helped Application Development Team in deploying and testing the application, which uses SQL Server 2005 backend.
Humana, Lancaster, SC Nov‘10 - May,2011
SQL Server DBA
Involved with upgrading from SQL Server 2000 to SQL Server 2005 on Development and Testing Environments.
Worked in 2- node Active/Active/Passive Clustered Environment.
Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
Involved in system requirements and the upgrade matrix for SQL Server 2005.
Involved in installation of SSIS in Clustered Environments.
Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Sever 2005 database using migration wizard.
Experience creating package configuration files for SSIS after migrating from DTS.
Created SSIS packages for the archive and purge process from all the production servers.
Experience transferring data from Access Server to SQL Server.
Experience in resolving blocking and Dead lock Issues by using SQL commands.
Extensively worked in Performance tuning, optimization of stored procedures and queries.
Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
Monitored Performance with SQL Profiler and using a monitoring tool called Quest Spotlight.
Used Quest LiteSpeed as Backup/Restore tool.
Creating Logins and Roles with appropriate permissions.
Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
Involved in creating various cubes using star and snow-flex schemas in SSAS.
Providing support to developers in Performance Tuning and Query Designing.
Environment: : MS Windows 2003/2000 Server, MS SQL Server 2005/2000, Oracle 10g, IBM e series Servers, Dell 6500 quad processors with 16 GB RAM, Quest LiteSpeed, Quest Capacity Manager.
HP, Greenville, SC May ‘10 - Nov ‘10
SQL Server DBA
Responsibility includes configuring, administration and troubleshooting multiple databases in development, QA and Production environments.
Successfully Upgraded from SQL Server 2000 to SQL Server 2005 on Testing, Development and Production Environment.
Generated test data and check databases consistency to meet the functionalities requirements.
Involved in Data Modeling and Designing
Created jobs, alerts, activity logs, error logs to capture any possible errors
Configured MS SQL Server 2005 in-built Mirroring as a Disaster Recovery.
Configured Various Replication Types between Primary Server and Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2000/2005 Environment to Test the Software.
Installing applications and establish the connectivity with the database.
Creating Stored Procedures to convert database tables into XML format and display via web.
Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS Packages.
Experience migrating DTS packages to SSIS manually for custom legacy systems.
Assist ETL Developers to write and debug SSIS packages.
Performance tuning, and optimization of procedures and queries.
Worked with SQL Server Profiler to generate traces.
Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
Used Notification Services Available In SQL Server 2005 to create alerts and email notification.
Helped Application Development Team in deploying and testing the application, which uses SQL Server 2005 backend.
Environment: MS Windows 2000 Data Center ,MS Windows 2003 Enterprise Server, MS SQL Server 2000/2005, Visual Studio 2005,IIS 6.0, HP ProLiant DL380 G4 with 12 GB RAM, Dell PowerEdge Servers, RedGate Backup
UNICOM TEC, San Jose, CA Aug'09– May‘10
Junior SQL Server DBA Intern
Responsibilities include tasks such as Database Backups and Restores, Log Shipping, Database Integrity Verification and Indexing updates.
Responsibilities include Upgrading for two applications from MS SQL Server 2000 to MS SQL Server 2005.
Installing, Configuring and Maintaining SQL Server 2005 with latest Service Packs, Hot Fixes.
Implement Log Shipping in SQL Server 2005 from primary server to Standby server.
Worked with on-site personnel or internal project manager to review problems, define and test solutions, and developed Ad hoc Queries and reports for user management.
Responsibilities include advising in Planning and designing the Logical and physical Data Modeling.
Help the team to write and tuned Stored Procedures, Triggers, UDF, Queries.
Extensively involved in documenting upgrading procedures and project plans from MS SQL Server 2000 to MS SQL Server 2005.
Monitored growth of data and managed space allocation accordingly.
Writing and tuning stored procedures, triggers, queries.
Use Full Text Search Service for search operation in journal database.
Installing applications and establish the connectivity with the database.
Worked with developers writing applications in Microsoft .Net.
Performance Monitoring with Performance monitor and NETIQ Appmanager.
Writing scripts to Create Jobs for Backup & Restore Plans.
Environment: Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL Server 2000/2005, Microsoft SQL Server Reporting Services 2000, Visual Studio.Net 2003, Compaq Proliants 8000/6500,IBM Fast T 700 Storage Area Network (SAN).
Positive Solutions, Hyderabad, India Aug’07 – Jul ‘08
SQL Developer Intern
Involved in various stages like development, system Analysis, and design for new application.
Designing and development of Interfaces and connected to Database using ADO technology for SQL Server.
Validating and coding the application using VB, ASP.NET.
Designed and validated the forms according to client requirement by using VB.
Implementing the database objects like stored procedures and Triggers.
Debugging and fixing the bugs.
Worked to create Software Requirement Specification (SRS) document.
Developed and coded applications in T-SQL.
Designing the Logical and Physical databases and development of SQL Server Database.
Database testing, maintaining the data and writing the procedures.
Environment: SQL Server 2000/7.0, T-SQL, Windows 2000/NT 4.0, HTML, VB 6.0, ADO, IIS, ActiveX.
Contact this candidate