SUMMARY OF QUALIFICATIONS

• Expert in Installation, configuration, and maintenance of SQL Server 2000,2005,2008,2008R2& 2012 and maintained Fail - Over Clustering using SQL Server 2008 R2/2008.
• Experience in Data Modeling (conceptual, Logical and Physical Design of Databases), Normalization, developing E-R Diagram using SQL server Database Diagram, ERWin 4.1.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Experience in T-SQL Programming skills, query optimization & performance tuning.
• Expert in Executing Plan, SQL Profiler and Performance Monitor, DMV and DBCC commands.
• Expert in Database backup and disaster recovery procedures.
• Experience in database HA Log shipping, Mirroring .
• Experience in Replication - Snapshot, Merge and Transactional.
• Extensive experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience and proficiency on the design, construction and implementation of Business Intelligence tools Star Schema, Data Warehouses, OLAP Cubes, Partitioning and ETL Process (Data Extraction, Transformation layer) with SSIS.
• Experience in creating SSIS and DTS packages for ETL purposes and using multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data to SQL Server databases using SSIS.
• Expert in Extracting, transforming, cleansing, and loading(ETL) from their legacy Access system to SQL server.
• Proficient in migrating Oracle 10g, 11g, and MySQL 4.3, 5.0.2 databases to SQL Server 2005 as well as SQL Server 2008, 2008R2.
• Creating complex DTS Packages for Data Migration and Transformation with experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Expert in SSIS/DTS to utilizing BCP for large file uploads into database.
• Proficient in OLTP&OLAP environment that includes Production (24x7), QA and development databases in SQL Server
• Experience in SQL server management tools like Enterprise manager, management studio, Query Analyzer, Profiler, Toad
• Extensive experience in Security and Grants, Managing Permissions for user/logins and assigning server/database roles.
• Experience in Automation and Monitoring Jobs, Alerts, SQL Mail/Database Mail, Pager and Notification Services.
• Knowledge of Analysis Services & Reporting Services, SQL Server Clustering, Log Shipping implementation knowledge of Database Data Warehousing with MS SQL Server 2008,2005,2000 & Analysis Services
• Knowledge of administration, maintenance, and support of MS Share Point server.
• Strong knowledge and experiences in administering Web Server (IIS) including installing, and configuring and monitoring
• Proficient in Link Server, Distributed Queries, Access 2003 and Zip, Unzip, Moving Files, FTP.
• Ability to work in a fast paced environment either independently or in a team
• Index (Cluster, Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.

TECHNICAL SKILLS

Operating System: Windows XP& 7, Windows Server 2003, 2000, NT 4.0, UNIX

Databases: MS SQL Server 2000, 2003, 2005, 2008, Oracle, DB2, Sybase, MS Access

Database Reporting: SSRS (SQL Server Reporting service), Crystal Report.

Data Modeling: SQL Server Database Diagram, ERWin Data Modeler. SQL Server ETL Tool SSIS, DTS, BCP SQL Server Management Tool Enterprise Manager, Management studio, Query analyzer, Profiler, Toad, DB Artisan

Networking/Communication: Windows NT Client/Server configuration, Firewall WEB Server IIS, Apache Tomcat

Network Protocol: TCP/IP, FTP, HTTP

Hardware: SAN (Storage), RAID (Data Files)

Programming languages: T-SQL

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Washington DC

Responsibilities:

• Installed, Configured, and Administered Operating Systems, Windows Server (2003 & 2008).
• Installed, Configured, and Administered SQL Server 2005&2008/2008R2 & 2012.
• Applied Service pack (SP) in 2000, 2005, 2008 and 2012.
• Build different database environment like development, test, and production.
• Implement database standards and naming convention for the database objects.
• Migrated databases from SQL Server 2000 to 2005 and2008 to 2012
• Build and deploy database from Staging to Production.
• Configure and Maintain mail server in all environment like 2000, 2005 & 2008.
• Configure Log Shipping from Production to Standby Server (Running as Reporting Server). Troubleshooting production issues and raising high availability.
• Perform Password Changes on cluster and maintain individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Develop DTS, SSIS, BCP to import & export data from flat files, excel to MS SQL Server database.
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
• Extensively experience in using DTS, BCP to import & export data from flat files, excel and MS Access to MS SQL Server databases.
• Implemented the SQL Server 2008 concepts like Snapshot isolation, database monitoring, database snapshot, DDL triggers, try-cache blocks, security with principals and securable etc.
• Configured and Administered Database High Availability solutions using
• Replications database server in 2000 & 2005,2008R2
• Log Shipping in 2000, 2005, and 2008,2008R2
• Database Mirroring in SQL server 2005,2008,2008R2
• Used profiler to verify/replicate the problematic queries to diagnose problems and take necessary actions.
• Created Backup strategy for production and development environment
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
• Scheduled jobs for backups, DBA notification if there is any failure, disk issues and also developed maintenance plan.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Provided 7 x 24 Production support for the database and application issues.
• Attended weekly Project Status Meeting with Development Team, Project Manager, and worked closely to define the critical path to meet project milestones.

Database Administrator

Confidential, Washington DC

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008R2 and MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• Actively participated in gathering of User Requirement and System Specification.
• Worked extensively on Managing SQL DB Environment of more than 9Terabyte in size, performance monitoring and alert management.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Created Jobs and scheduled jobs according to the requirements.
• Implemented Transactional replication between Primary Server and Sub Systems.
• Created database, tables, Indexes and views and linked server between SQL servers.
• Written complex stored procedures and functions and integrated it with the front end application.
• Involved in performance tuning and query optimization.
• Data transfers between various servers using BCP, DTS and SSIS
• Used SSIS to move data from heterogeneous data sources to SQL Server.
• Designed complex information in Microsoft Office Visio 2007 to visualize, explore, and Communicate
• Involved in migrating databases from MS SQL server 2005 to MS SQL server 2008R2.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
• 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
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Designed and implemented monitoring tool for capturing Log Events for Production Servers performance monitoring and alert messages for blockings
• Involved in tuning the database by tuned the SQL queries using SQL profiler.
• Implementing stand by servers and log shipping.
• Maintaining proper licenses Estimated table sizes and record sizes.
• Solved critical production problems and performed point in time recovery plans.
• Maintain all SQL documents include installation and data conversion procedures documents and presented daily and weekly report to Project manager.
• Extensively used SQL server Reporting services for designing reports.
• Provided on - call 24/7 provide support.

Database Administrator

Confidential, CT

Responsibilities:

• Installed, Configured, and Administered Operating Systems, Windows Server 2000
• Installed, Configured, and Administered SQL Server 2000 and 2005.
• Applied Service pack in 2000 and 2005.
• Designed and created databases, tables, views, stored procedures and triggers
• Upgraded databases from SQL Server 2000 to 2005.
• Export & Import data from flat files, excel and MS Access to MS SQL Server databases through DTS.
• Developed Database Maintenance Plan
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes
• Created Backup strategy for production and development environment
• Database Backup & Restore
• Designed and created databases, tables, views, stored procedures and triggers
• Monitor Servers activity, Server Error Log, space usage.
• Regular Monitor of Servers like activities against database, Error Log, space usage
• Designed and implement database logical and physical Schemas using Erwin 3.5.
• Backup and recovery plans for Field office and Headquarters database servers. Also maintained the field office database backup through SQL mail scripts.Interacting with the users and troubleshooting the problems involved with the development of stored procedures.