SUMMARY

• Over Eight years of IT experience which includes Database Administration, Development, Support of MS SQL Servers 2000/2005/2008 in Production, Development & QA environments.
• Three years of Oracle Database Administration experience.
• Hands on Experience in MS SQL Server Installation, Configuration, Performance Monitoring, Security Administration and Replication, Database mirroring & clustering.
• Experience in designing and implementation of efficient Backup, Restore, Maintenance, Disaster Recovery & High Availability Strategies.
• Experience in developing and monitoring DTS and SSIS Packages.
• Extensive noledge of creating and maintaining SSRS reports.
• Successfully performed upgrades from SQL . Currently involved in SQL 2005 to SQL 2008 migration.
• Handling and managing VLDB SQL Server Environment wif database sizes varying from 200 GB - 1.4 TB.
• Expertise in handling all major day to day SQL Server Database Administration activities.
• Experience wif Log Shipping, SQL Mail and SMTP configuration.
• Worked wif Lead Developers to solve performance issues and suggested changes such as indexing, code change.
• Experience wif implementing MS SQL Cluster(Active/Active, Active/Passive) upto 5 nodes.
• Good noledge of SQL backup tools such as LightSpeed, Veritas Netbackup
• Team player wif good analytical, communication and inter personal skills.
• Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows Server 2000/2003/2008

Databases: SQL Server 2000/2005/2008 , Oracle 9i/10g.

Languages: C, Java,.NET, XMLNetwork Protocols TCP/IP, Named Pipes.

Other Tools: Crystal Reports, Business Objects, Visual Studio 2005, LightSpeed, Veritas Netbackup

PROFESSIONAL EXPERIENCE

Confidential, Springfield, MA

SQL Server Production DBA

Responsibilities:

• Part of teh Database Administrator group dat supports more TEMPthan 4 clustered servers including Unit Test, System Test, Preprod and Production.
• Installed, Configured and Maintained SQL Server 2005 & SQL Server 2008.
• Installed different versions of Oracle(9i, 10g) on different operating systems.
• SQL Server Administration activities such as Creating and Managing Databases, Import/Export, Maintaining Transaction Log, Backup & Restore, Performance tuning, Security and User Management.
• Managed VLDB(Very Large Databases) of over 400 GB’s
• SQL Server development activities like creating tables, views, stored procedures and triggers using T-SQL.
• Worked on migration of SQL Server 2005 from Windows 2003 server.
• Presently involved in SQL migration.
• Involved in synchronization of different instances of databases.
• Involved in development and deployment of SSIS packages.
• Involved in development and deployment of SSRS reports.
• Involved in 24/7 on call production support.
• Involved in migration of SQL and Oracle change requests which includes migrating teh changed objects from system test to production instances.
• Used LightSpeed and Veritas Netbackup for database backups and restores.
• Used RMAN & other Oracle utilities for Oracle backups.
• Configured RMAN for scheduling backup directly to tape using Veritas Netbackup.
• Used Database Configuration Assistant(DBCA), Database Upgrade Assistant(DBUA) for migrating Oracle 9i to Oracle 10g.
• Database Refreshes as requested by Development and Testing Teams.
• Actively involved in day-to-day troubleshooting, supporting development operations.
• Assisted developers in testing stored procedures, functions, views, cursors, packages for maintaining tables, retrieving data from production.
• Regular coordination wif DBA team in India for nightly activities.
• Created and maintained SQL jobs for various tasks, such as backup, maintenance, and various applications.
• Created and Maintained environmental documentation by updating documents to reflect infrastructural changes.
• Facilitated/Participated in teh planning, testing, and implementation of new/upgraded infrastructure.

Environment: Windows 2003/2008 Server, SQL Server 2005/2008, LightSpeed, Veritas Netbackup, Oracle 10g, .NET

Confidential, Tampa, FL

SQL Server Development DBA

Responsibilities:

• Managed teh Database Administrator group dat supported more TEMPthan 6 clustered servers including Training, System Test, Development, Staging, UAT and Production. their were 2 nodes on each cluster having 20 instances of SQL Server databases.
• Installed, Configured and Maintained SQL 2005 & SQL Server 2000 wif SP4 on new servers
• Managed VLDB(Very Large Databases) of over 600 GB’s
• SQL Server Administration activities such as Creating and Managing Databases, Import/Export, Maintaining Transaction Log, Backup & Restore, Tuning, Performance Optimization, Security and User Management.
• SQL Server development activities like creating tables, views, stored procedures and triggers using T-SQL.
• Actively involved in day-to-day troubleshooting, Supporting Development operations.
• Worked on migration of SQL Server 2000 from Windows 2000 server to SQL Server 2005 in Windows 2003 server in a clustered environment.
• Involved in synchronization of different instances of databases.
• Involved in development and deployment of SSIS packages.
• Involved in 24/7 on call production support.
• Developed Backup & Restore Strategies for Databases.
• Implemented SQL Analysis Service cubes.
• Database Refreshes as requested by Development and Testing Teams.
• Created and Maintained environmental documentation by updating documents to reflect infrastructural changes.
• Facilitated/Participated in teh planning, testing, and implementation of new/upgraded infrastructure.
• Created and maintained SQL jobs for various tasks, such as backup, maintenance, and various applications
• Worked on Active/Active clusters on SAN

Environment: Windows 2003 Server, SQL Server 2000/2005, Analysis Services, Integration Services, Reporting Services, IIS6.0 and MS Visual Studio.NET.

Confidential

SQL Server DBA/Production Support

Responsibilities:

• Part of a Development team dat supported more TEMPthan 5 Development servers including Development, Test, Staging & QA environments
• Installed, Configured and Maintained SQL Server 2000 wif SP3 on new servers
• SQL Server Administration activities such as Creating and Managing Databases, Import/Export, Maintaining Transaction Log, Backup & Restore, Tuning, Performance Optimization, Security and User Management.
• Actively involved in day-to-day troubleshooting, Supporting Development operations.
• Worked on migration of user databases from old servers to new servers.
• Used T-SQL to write complex stored procedures and triggers.
• Experience wif database management jobs, DTS/SSIS packages and overall performance monitoring
• Developed Backup & Restore Strategies for Databases.
• Database Refreshes as requested by Development and Testing Teams.
• Created and Maintained environmental documentation by updating documents to reflect infrastructural changes.
• Facilitated/Participated in teh planning, testing, and implementation of new/upgraded infrastructure.
• Created and maintained SQL jobs for various tasks, such as backup, maintenance, and various applications

Environment: SQL Server 2000 Enterprise Edition, Enterprise manager, Sybase, Query Analyzer, .NET, MS Excel and Windows 2000 Advance Server.

Confidential

SQL Server DBA/Support

Responsibilities:

• SQL Server Administration activities such as Creating and Managing Databases, Import/Export, Maintaining Transaction Log, Backup & Restore, Tuning, Performance Optimization, Security and User Management.
• Worked on migration of jobs and DTS packages from old servers to new servers. Configuration, installation, maintenance of all Windows 2000/2003 servers hosting SQL Server 2000/2005.
• Developed SQL jobs to carry out tasks like backups, audits, reports, etc. and scheduled them using SQL agent.
• Worked wif SQL queries on very large tables.
• Configured and Maintained Database Maintenance Plans for all teh Databases
• Developed Stored Procedures to gather data for audit reports.
• Designed DTS packages for different tasks
• Troubleshooting of failed jobs
• Collaborated wif software engineers, architects, and technology specialists to design database, clustering, and migrations.
• Identified, communicated and recommended mitigations of technical database issues and risks dat could impact project success

Environment: SQL Server 2000/ 7.0, Visual .NET, Enterprise Manager, Crystal Enterprise Server, Query Analyzer, T-SQL, IIS 5.0 and Windows 2000.

Confidential

SQL Server DBA

Responsibilities:

• Installed & Configured MS SQL Server 2000 Databases for Production, Test, Development, QA and Demo instances
• Applied Service packs and security updates to teh Database.
• Configured and Maintained Database Maintenance Plans for all teh Databases.
• Analyzed and Configured Database Backup and Restored Strategies such as Transaction Log Backups, Differential Backups and Full Backups
• Database Refresh as requested by Development and Testing Teams.
• Wrote and tuned Transact SQL ‘ad-hoc’ Queries, Triggers and Stored Procedures.
• Worked wif Performance Monitor & SQL Profiler to resolve any Performance issues as required
• Processed migrations to Testing and Production databases quickly and efficiently adhering to Change Management standards.
• Supported and participated in maintaining a current application infrastructure.
• Helped developers and other technical team members to troubleshoot issues wif Databases and Applications.

Environment: Windows 2000, SQL Server 7.0/6.5, VB, VBScript, JavaScript, and Crystal Reports.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Supported 40 Instances of MS SQL Server 2000, for Applications such as Siebel CRM
• Installed & Configured MS SQL Server 2000 Databases for Production, Test, Development and Staging instances
• Used T-SQL to create databases and database objects like tables, views
• Database Refresh as requested by Development and Testing Teams.
• Configured and Maintained Database Maintenance Plans for all teh Databases.
• Analyzed and Configured Database Backup and Restored Strategies such as Transaction Log Backups, Differential Backups, Full Backups and Tape Backups.
• Wrote and tuned Transact SQL ‘ad-hoc’ Queries, Triggers and Stored Procedures.
• Monitored, Detected, Analyzed, fixed and communicated problems dat degrade teh predictable delivery of business application services.
• Worked wif Performance Monitor & SQL Profiler to resolve any Performance issues as required
• Processed migrations to Testing and Production databases quickly and efficiently adhering to Change Management standards.
• Created and Maintained environmental documentation by updating documentation, in a timely fashion, to reflect infrastructure changes, tuning procedures, other techniques.
• Supported and participated in maintaining a current application infrastructure.
• Applied Service packs and security updates to teh Database.
• Facilitated/Participated in teh planning, testing, and implementation of new/upgraded infrastructure.
• Helped developers and other technical team members to troubleshoot issues wif Databases and Applications

Environment: SQL Server 7.0, Visual Basic 5.0, Crystal Reports and Windows NT.

Confidential

DBA/Developer/Data Analyst

Responsibilities:

• Install SQL Servers, create devices, databases, add users, grant permissions, code stored procedures and triggers
• Backup, recovery and restoration of databases on MS SQL Server
• Analysis of teh design of teh database on DB2 and providing similar design on SQL Server
• Support multiple systems and applications
• Determining storage requirements and planning
• Preparing test environments for Integration testing and Regression testing and Parallel testing
• Logical and Physical data modeling.

Environment: MS SQL Server 7, VB, and Windows NT