SUMMARY:

With over 12 years of technology experience in both small and large organizations, I am seeking a challenging position in a dynamic organization where I can apply my technical expertise, leadership skills, team work, and enthusiasm towards a long - term career in information technology. I have reputation as an innovative, dedicated and result-driven professional.

TECHNICAL SKILLS:

Databases: SQL Server 2012/2008/ 2005/2000, MS Access.

Operating systems: Windows 2012, 2008 R2/XP/ 2003/2000/ 98/95/ N.T

Backup Tools: Lite Speed, Symantec Net Backup.

Performance & Monitoring: Idera Diagnostic, SCOM (System Center Operation Manager)& HP.

PROFESSIONAL EXPERIENCE:

Confidential, IL

SQL Server DBA

Responsibilities:

• Database Administrator, database migrations.
• Directly involved to work with Application team, internal customer and external vendors on small and large projects.
• Periodically checked all databases with DBCC commands for maintaining data consistency and integrity.
• Wrote complex queries, User Defined Functions (UDF’s) and Stored Procedures.
• Deployed database objects from development to testing environment and to production environment.
• Involved in all new projects/application development based on SQL Server, Client/Server Environment.
• Install and configure SQL server 2008, 2012 R2 on cluster servers using Symantec Veritas Cluster server administration.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Recovering the databases from backup in disasters.
• Create change orders using service now utility.
• Administering the database standards and managing the database sizing on share point portal as repository system.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Confidential, VA

SQL Server DBA

Responsibilities:

• Define corporate wide SQL Server standards and manages Databases.
• To perform Migration of databases from Legacy to new MSP VM environment, Prod, Pre-Prod & QA.
• To install and configure SSAS and SSRS on VM Ware SQL 2008 build.
• Identifies opportunities in SQL environment and designs and tests technical solutions.
• To collaborate with business IT and production support to confirm that the solution has solved the problem.
• To administer and setup the VM environment for medium and small scale production databases.
• Responsible for creation and administration of standards, procedures and practices regarding SQL Server database technology.
• Test and certify patches. Install & Post install validation of SQL Server 2008 for new VM Ware environment.
• Coordinate training/ mentoring sessions of application dba’s about new features, and their applicability in Confidential environment.
• Database backup, monitoring, and performance management solutions.
• Assist platform managers with capacity management of SQL Server databases and assignment of servers for new databases.
• Create Change order using HPSM.
• To take care of Post Migration Scripting & Execution.
• Decommissioning of the databases after Migration.

Environment: Windows 2008 server, MS SQL Server 2000, 2005 (Enterprise Manage, Query Analyzer), and SQL Server 2008 T-SQL, MS Excel.

Confidential, NJ

SQL Server DBA

Responsibilities:

• Architect and legacy application development teams to complete design, development and support activities.
• Responsible for storage management, performance, monitoring and tuning of the database.
• Design and implement Security policies as per the business requirement for SQL Servers.
• Design and implement comprehensive Backup plan and disaster recovery strategies; Implement and Schedule Replication process for updating our parallel servers.
• Automate messaging services on server failures, for task completion and success.
• Expertise writing and fine tuning T-SQL & database services
• Managed availability, backup, restoration and recovery systems with the database.
• Assist IT staff in the deployment of developed database software.
• Changed activation and implementation validation.
• Implementation and support of complex data warehouse full and incremental SSIS feeds.
• PL/SQL commands handling and implementations accordingly.
• Design and implement comprehensive Backup plan and disaster recovery strategies Implemented.
• Manage and report time spent on all work activities.

Environment: Windows 2008 server, MS SQL Server 2000, 2005 (Enterprise Manage, Query Analyzer), and SQL Server 2008 T-SQL, MS Excel.

Confidential, Columbus, OH

SQL Server DBA

Responsibilities:

• Built and administered new SQL 2008 installations.
• Migrated older MS SQL databases from MS 2000 to MS SQL 2005.
• Developed, published and maintained database operations manual under revision control.
• Extensive Windows Server Administration.
• Supported data migration and testing activities in Integration user acceptance testing and production environments.
• Implementation and support of complex data warehouse full and incremental SSIS feeds.
• Maintained database integrity and security.
• Handled storage management, performance, monitoring and tuning of the database.
• Designed and implemented Security policies as per the business requirement for SQL Servers.
• Automated messaging services on server failures, for task completion and success
• 24 x 7 Production Support / On Call.
• Managed availability, backup, restoration and recovery systems with the database.
• Assisted IT staff in the deployment of developed database software.
• Changed activation and implementation validation.
• Support high volume OLTP trans and OLAP batch processes
• Monitored database system resources and performance.

Confidential, PA

SQL Server DBA

Responsibilities:

• Responsible for data dictionary backup and recovery.
• Responsible for definition of standards of data dictionaries.
• To maintain database user logins, passwords and privileges.
• Build and administer new SQL 2005 installations.
• May program dictionary analysis and maintenance software.
• Migrating tables/data across these different versions of SQL Server and determining the impacts to current applications with the upgrade in SQL Server versions.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Manage and report time spent on all work activities.
• Backup / restore databases, monitor alerts, trouble-shooting, setup/modify log shipping and replication.

Environment: Windows 2003 server, ASP, XML, MS SQL Server 2000, 2005 (Enterprise Manage, Query Analyzer), T-SQL, MS Access, MS Excel.

Confidential, NY

SQL Server DBA

Responsibilities:

• Created all administration tasks of SQL Server and designed database.
• Created and modified procedures, triggers and functions.
• Used System procedures and DBCC commands.
• Regarding Crystal Reporting - Understanding Tables, Records, and Fields, Learning About Link in, Adding Multiple Tables to a Report, Producing, Editing and Formatting Charts.
• Implemented various levels of constraints and triggers to preserve long term database consistency and accuracy.
• Created and supported complex database schemas.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• Monitored the clustering environment.

Environment: Windows 2003 server, ASP, XML, MS SQL Server 2000, 2005 (Enterprise Manage, Query Analyzer), T-SQL, MS Access, MS Excel, Oracle.

Confidential

SQL DBA/ Developer

Responsibilities:

• Involved in logical and physical design of databases.
• Wrote stored procedures, triggers and views for applications.
• Setting up and implement test and production environments for general ledger, human resources and payroll management systems.
• Migrated the application from SQL Server 7.0 to SQL Server 2000.
• Managed various access-related issues pertaining to database performance and efficiency.

Environment: SQL Server 6.5/ 7/ 2000, Oracle 7.x/8, Oracle Financials 11, Developer 2000,Visual Basic, FoxPro, Windows NT 4.0/ 2000/ 98/ XP.