OBJECTIVE

• To get a challenging position as a DBA in IT Industry and work towards the growth and development of a progressive organization.

TECHNICAL SKILLS

Database: SQL Server 2008/2005/2000, MS Access 2007/2003/2000, MYSQL, Sybase, Oracle

SQL Tools: SSMS, Query Analyzer, Profiler, SQL, MAIL, SQL Agent, TOAD, ETL

SQL Server Utility: SSIS/DTS, Jobs, BCP, OSQL, ISQL, Link Server, ODBC

Database Reporting: SSAS/OLAP. SSRS, Business Object, SAS, COGNOS

Data Modeling: SSDD, MPD, ERWIN 4.1 and VISIO 2003/2007

Languages: T - SQL, Store Procedures, Trigger, Web DesignOperating System: Windows XP/NT 4.0, Windows Server 2008/2003/2000, MS-DOS, UNIX, VSAM

Hardware: Cluster, VMware, SAN, RAID, Xeon, Multi-Processor

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Chicago, IL

Responsibilities:

• Installing and Configuring SQL Server 2000, 2005 and 2008
• Upgrading/Migrating and Consolidating databases from different DBMS and versions to current version of SQL Server
• Updating Service packs and Security patches for the Servers
• Performing Database Administrator duties Data Modeling using ERWin
• Designing Logical & Physical Database using ERWin
• Backward & Forward Engineering using ERWin
• Involved in creating and modifying tables, Index (Cluster/Non - Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Suggested, developed & implemented Scaling out solution with Data partitioning
• ETL Data Modeling.
• Managing and configuring SQL Servers as Linked servers as well as setting configuration options
• Troubleshooting and writing stored procedures, triggers, Functions, views and make changes to the code if necessary
• T-SQL queries to diagnose data problems and fix scripts to correct the data problems
• Ensuring data integrity and referential integrity by using constraints
• Backing and Restoring of database
• Disaster recovery procedures to ensure minimal downtime and data loss.
• Using data transformation services to move data between different sources and transform data according to needs
• Configuring and monitoring replication and log shipping and Debugging deadlocks and other database inefficiencies using SQL Profiler.
• Performance Tuning - Tune, analyze and optimize costly queries

Environment: SQL Server 2005/2008, C#, T-SQL, Visio, SSRS, SSIS/DTS

Database Administrator

Confidential, Seattle, WA

Responsibilities:

• Installed, upgrade and Configure SQL Server 2000 & 2005 in development, test, and production environment.
• Extensively worked on Data partitioning and Snapshot isolation in SQL Server 2005
• Performed daily tasks including backup, and restore by using SQL Server 2005/2008 tools like SQL Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Monitoring SQL Server performance using profiler to find performance and dead locks
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Polices for various categories of users
• Imported data from Oracle and Excel to SQL Server Databases using DTS
• Involved in disaster recovery
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server)
• Designed and created databases, tables, views, stored procedures and triggers
• Configured and Maintain Replications (Transactional)
• Writing T-SQL and Stored-ProceduresPerformance tuning
• Developed Database Maintenance Plan
• Export & Import data from other data sources like flat files using Import/Export through DTS and SSIS
• Worked on SQL Server tools like Enterprise Manager and SQL Query Analyzer
• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment
• Managing and Configuring SQL Servers as Linked servers as well as setting configuration options
• DBA activities like analysis of Space Availability, Backup and Restoring
• Tracking health of the Server
• Configuring and monitoring Replication /Log shipping
• Tuning Databases for performance
• Scheduling of DTS/ SSIS Packages and Deployment

Environment: SQL Server 2000/2005, Visual Basic 5.0, and Win NT

Database Administrator

Confidential, Seattle,WA

Responsibilities:

• Installed, Configured and Maintained SQL Server 2000 and 2005
• Installed and Maintenance Plan Configured Operating System, Windows Server (2000 & 2003 )
• Migrated databases from SQL Server in test and production environment
• Configured and Maintained Replications (Transactional)
• Writing T-SQL, Stored-Procedures, and trigger
• Performance tuning & index tuning
• Assist SQL developers to optimize SQL queries and Stored Procedures
• Created Backup strategy for production and development environment
• Database Backup & Restore and scheduled jobs.
• Monitor Servers activity, solving problem
• Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database
• Work experience and strong knowledge in disaster recovery

Database Project Administrator

Confidential

Responsibilities:

• Created, administered & maintained Business Databases using SQL statements.
• Delivering updated business software
• Database customer service.