SUMMARY

• Over Five years of experience in the use and Administration of SQL Sever 2000/05/08 database.
• Deep knowledge in Relational Database Management (RDMS) concepts.
• Experience in designing, implementing, maintaining and documenting complex database applications.
• Experience with Installation/Configuration and administration of SQL servers (2000 and 2005) in both Clustered/Non-Clustered environments.
• Experience in using Microsoft built in and Third Party tools like SQL Profiler, Windows, Performance Dashboard Report, DMV, DMF, PerfMon Performance Counters, Error Log, Event Viewer for Monitoring and Tuning MS SQL Server Performance.
• Experience in creating Store Procedures, Functions and Triggers.
• Experience in T-SQL to write Store Procedure, Tables, Functions, Views, and Indexes.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience with SQL Server 2005 DDL/DML Triggers, Database Mirroring, Migration, Upgrading.
• Experience in creating proper back up strategy for disaster recovery.
• Possess excellent written and verbal communication and interpersonal skills.

EDUCATION:
Bachelor of Science Degree in Computer Science and Technology
MICROSOFT CERTIFIED PROFESSIONAL:
070-228: Installing, Configuring and Administering Microsoft SQL Server 2000 Enterprise Edition

TECHNICAL SKILLS:

• Operating Systems: Windows95/98/2000/NT 4.0/XP/2003 Server, MS DOS, UNIX, Linux
• Languages: C, C++, C#, Java, J2EE, Struts, JSP, Servlet, T-SQL, PL/SQL, MySQL, Oracle
• Web Technologies: HTML, DHTML ASP.Net, ADO.Net
• Web server Technologies: IIS 5.1/6.0, IBM Web Sphere
• Data Bases: MS SQL 7.0/2000/2005, Oracle 9i/8i, DB2, MS-Access, Paradox 7.0
• Front End: Visual Studio 2005, Business Intelligence Development Studio, SQL Server Management Studio, Enterprise Manager

PROFESSIONAL EXPERIENCE:
Confidential,New Jersey Sep 2008 to Dec2010
SQL Server DBA

Description: Confidential,is one of the largest retail banking and financial services, conduct’s the business though retail banking & financial services, home loans, commercial banking, and card services. The goal of this project was to install and configure SQL server 2005 in binary sort order. Test and Modify scripts and monitor Citi database system.

Responsibilities:

• Installed and Configured SQL server 2005 and 2008 in 32 bits and 64 bits Enterprise Editions in Binary Sort Order and in Default Collation.
• Installed and Maintained all DBMS and related software like BMC Best1, IBM Tivoli Client, Terminal Server Service, and Net backup Client, SQL Server 2005 Hot Fixes and Service Packs 1 and 2, Guardium SQL Client.
• Experience working with Project Management tools (like PlanView, Clarity, HP-PPM etc.)
• Worked with active/active and active/passive clustered environment up to six nodes.
• Verified and Tested scripts written by programmer in UAT, and Production environment.
• Established and Maintained all DBMS operating environments (Development, Q/A, and Production) on hosts/servers in CGTI Data Centers.
• Monitored performance and tuned all DBMS subsystems. Supported application performance review and tuning efforts.
• Moved changes made to development servers to test servers for testing and, once testing is done, to move the changes to production.
• Experienced in using index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning Server Performance.
• Utilized diagnostic tools to identify database performance bottlenecks.
• Worked with two partitions (C: and D) created on local disk.
• Managed and monitored to ensure adequate CPU, Disk Space, and Memory on SQL Server 2005.
• Tested and modified backup Jobs and scripts based on Binary Sort Order.
• Created proper back up strategy using Full, Transaction and Differential to minimize data lose and Simple, Full and Bulk-Logged Recovery models to restore and recover the data.
• Monitored CPU utilization using BMC Patrol.
• Created and Modified Jobs on daily basis, and set up the email notification on unsuccessful Jobs using SQL mail.
• Performed database security configuration and administration.
• Replicated data using Transaction, Snapshot and Merge methods.
• Maintained and monitored replication agents.
• Developed Capacity Planning, Performance Tuning and Disaster Recovery.
• Involved in Documentation.
• Experienced working with a global, (off-shore) team.

Environment: SQL Server 2000/2005/2008, Windows 2003, Enterprise Manger, Management Studio, SQL LiteSpeed backup, MS Reporting Service Crystal Report, Data Transformation Service, SQL Profiler, T-SQL.
Confidential,Washington April 2007 to May 2008
SQL Server DBA

Description: Confidential,is one of the largest retail banking and financial services, conduct’s the business though retail banking & financial services, home loans, commercial banking, and card services. The goal of this project was to upgrade the SQL Server database from 2000 to 2005.Generate reports from different data source and monitor the system using built in SQL Server tools.

Responsibilities:

• Responsible for installation, configuration and maintenance of SQL Server database on different platforms.
• Performed weekly re-index of production databases.
• Created DTS packages to import and export data from SQL Server to Access, Text and Excel files.
• Involved in design and generation of reports for different data source, performing transformation and loading that data into another data sources.
• Provided support on all stages of database implementation and/or database related deployments.
• Created proper back up strategy using Full, Transaction and Differential to minimize data lose and Simple, Full and Bulk-Logged Recovery models to restore and recover the data.
• Ran SQL Profiler to identify expensive queries and used database Tuning Adviser and query analyzer.
• Designed and created Views, documented the table relationships with diagrams.
• Imported and mapped the data to create tables and temp tables to research issues.
• Created and managed logins, roles, assigning rights and permissions to the users.
• Created and modified database objects, including tables, indexes, views and store procedures.
• Monitored database performance and rebuilt indexes on tables using index-tuning wizard to return quicker response time.
• Used ADO.Net 2.0 for SQL Server 2000/2005 access.
• Configured SQL Server 2005 in-built log shipping from primary server to standby server.
• Utilized various Replication methods to synchronize data at multiple targets.
• Created and modified Jobs on daily basis, and set up the email notification on unsuccessful Jobs using SQL mail.

Environment: SQL Server 2000/2005, Windows 2003, Enterprise Manger, Management Studio, Veritas, SQL LiteSpeed backup, Crystal Report, MS Reporting Service, MS Integration Service, Data Transformation service, SQL Profiler, T-SQL.

Confidential,New Jersey Feb 2006 to Feb 2007
SQL Server DBA

Description: Confidential,has been serving the healthcare needs of central New Jersey over 100 years.

Responsibilities:

• Upgraded to latest version from SQL Server 2000 to Server 2005.
• Developed Backup Restore script for SQL Server as needed.
• Scheduled Jobs and Alters.
• Designed and implemented data access Store Procedures and Triggers for automating task.
• Resolved any Deadlock issues with the database/server on a real time basis.
• Designed and implemented user log in and security.
• Managed capacity planning and monitored database growth.
• Tuned SQL statement and Store Procedure using Cluster and Non-Cluster Indexing method.
• Converted data from text file in to SQL Server 2005.

Environment: SQL Server 2000/2005, Windows server, Enterprise Manger, Management studio.
Confidential,New Jersey Jan 2005 to Nov 2005
SQL Server DBA

Responsibilities:

• Performed daily Backup and Restore on routine basis.
• Created student ID and password for other DBA and SQL Server users.
• Created Tables, Store Procedures, Function and Triggers to perform task.
• Created DTS packages for various data feed from different location.
• Replicated data using Transaction, Snapshot and Merge methods.
• Performed routine backup and restore on changes made on SQL databases.
• Monitored and maintained replication agents and replicated data.
• Restored SQL services and assigned permissions to the users to access databases and views.

Environment: SQL Server 7.0/2000, Enterprise Manger, and T-SQL Windows 98/2000.

Confidential,New Jersey May 2002 to Dec 2004
Desktop Support Specialists

Responsibilities:

• Responsible for providing desktop support for hardware, software, application issues, remote access, network and local printing.
• Set up new systems - laptops and desktops.
• Managed customer’s expectation by acknowledging their issues, providing ETA, etc.
• Provided updates to customers whose issues are outstanding at the end of the day.
• Worked with management when executives have desktop issues and need specific attention.
• Ticketed all issues including phone calls, emails and walk-ins.
• Tracked all ticket activity to ensure timely resolution of issues.
• Followed proper escalation procedures for issue handling and resolution.
• Thoroughly updated tickets with resolution information to enhance issue resolution database.
• Provided desktop application support.
• Provided system administration and Citrix administration support.