SUMMARY:

Certified SQL Server DBA has 6 years of experience in SQL Server Database Administrator/ DBA, analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments. Solid experience in the areas of installation, configuration, maintenance, Replication, Log Shipping, Mirroring, Clustering, Database backup and disaster recovery procedures, Data Modeling Logical and Physical Design of Databases , building Referential Integrity Constraints. Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions, and T-SQL Programming skills. Experience in query optimization performance tuning, used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands. Has good knowledge in complete ETL cycle including data analysis, database design, data mapping and conversion and data load, SSIS Packages for Data Migration and Transformation including data migration from Oracle/Access/Excel Sheets to SQL Server 2012, 2008 R2/2008, 2005. Solid experience in MS SQL Server upgrades from 2005 to 2008 R2 and 2012. Worked in OLTP OLAP environment that includes Production 24x7 , QA and development databases in SQL Server. Data Warehouse experience includes Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store ODS . Has Knowledge of Analysis Services Reporting Services, SQL Server Clustering and Log Shipping. Has knowledge on Share Point, Active Directory and VMware. Has very strong background in a disciplined software development life cycle SDLC process and has excellent analytical, programming and problem solving skills. Has the ability to work in a fast paced environment, Good team player and can work independently.

Quick view of TECHNICAL SKILL:

PROFESSIONAL EXPERIENCES

Confidential

SQL Database Administrator/DBA

Major responsibilities:

• Installed, Configured and Maintained SQL Server 2008 R2 2012 in Development, Test, and Production environment
• Upgraded SQL Server 2005 to 2008 R2 and 2005/2008 R2 to 2012
• Migrated MS Access 2003/2007 databases into MS SQL Server 2008 R2
• Migrated Oracle 10gR2 databases to MS SQL Server 2008 R2 using SSMA for Oracle
• Imported and exported data between SQL Server and other different sources
• Installed, Configured and Managed Database Mirroring, Replication and Log Shipping
• Maintained Fail-Over Cluster Servers in SQL Server 2008R2
• Designed EDR Enterprise Disaster Recovery solutions, Designed backup strategy, Point-in-Time recovery, Rebuild databases using backups, LSN, Point-Time-Time
• Schedule and monitor new or existing automation jobs on Test and Production environment
• Created Jobs for database maintenance Index fragmentation, rebuild, database statistics
• Maintained security by creating and monitoring user logins and groups with appropriate role in Server level and as well as object level permissions
• Involved in Data modeling, Database Redesign using ERWin, Designed Logical, Physical Database, E-R Diagram, Forward Engineer and Re-engineering
• Wrote SQL, T-SQL, Stored-Procedures and triggers
• Monitored Servers activity, slow performance, query performance, Stored procedure performance and solved related issues, managed locked, blocked, deadlock
• Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers
• Created and managed Indexes, Constraints, Primary/ Foreign Keys
• Managed SQL Server Error Logs, space usage, growth pattern
• Used ETL tools like DTS, SSIS, Import/Export, BCP Bulk Copy , to import export data from flat files and excel to MS SQL Server databases
• Installed, Configured SQL Server Reporting Services SSRS and Maintained security
• Developed and Deployed Reports, and Managed Security
• Excellent presentation and documentation skills

Environment: C , Java, MS SQL Server, Windows Server, MS Access, Share Point, SSIS, UNIX, Oracle, .NET, ASP.NET, XML, HTML

Confidential

SQL Database Administrator/DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008R2/2008, 2005 2000 in development, test and production environment
• Installed and Configured SQL Server 2008R2/2008, 2005 and 2000 for testing different features and stability
• Maintained Fail-Over Clustering using SQL Server 2008 R2
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 R2
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications Transactional
• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Database Upgraded development, testing and production environment : SQL Server 2000 to 2005
• Involved on data modeling projects and generated E-R Diagram
• Data Modeling tools used using Erwin, Toad Data Modeler, SQL Server Data Diagram
• Backward Forward Engineering with data modeling tools mentioned above
• Applied SP Service Pack on SQL Server 2000, 2005 2008R2
• Applied HOT Fixes on SQL Server 2000, 2005
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including backup, monitoring database health, index rebuild or reorganized and backup verification
• Monitor SQL Server Error Log, space usage
• Wrote SQL/T-SQL, Trigger and Stored-Procedures
• Export Import data from Flat file, CSV file to/from SQL Server Database using DTS,SSIS, and BCP
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Restored Database from backup
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Strong working experience in creating, modifying tables, Index Cluster/Non-Cluster , Constraints Unique/Check , Views, Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, and solving problem as needed

Environment: .Net, C , Java, XML, MS SQL Server, Windows Server, UNIX, Oracle, MS Access, SSIS, ASP.NET

Confidential

SQL Database administrator/DBA

Major Duties:

• Installed, Configure and maintained SQL Server 2005 and 20082 in Test and Production environment.
• Applied Service Pack on SQL Server 2000, 2005 and 2008 R2
• Migrated databases from SQL Server 2000/2005 to 2008 R2 in Test and Production environment
• Migrated MySQL databases into SQL Server 2008 R2 using SSMA for MySQL
• Closely worked with business analyst to collect requirements make systems available ASAP
• Work experience in disaster recovery
• Rebuild Servers Restore Recovered from tape/CD backup from backup
• Configured Log Shipping from Production to Standby Server Running as Reporting Server
• Configured and Maintained Replications Transactional
• Writing T-SQL and Stored-Procedures
• Created Backup strategy for production test and development environment
• Database Backup Restore manually and deployed in Dev, test and production
• Created and maintained different maintenance plans to optimize databases
• Setup and configure Database mail for notification purposes
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code
• Monitor Servers activity, solving problems
• Used ticketing system for managing tickets
• SQL Server Error Log, space usage
• Used DBCC to check physical and logical consistency of database and Rebuilding indexes
• Export Import data from Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files into SQL Server databases
• Experienced in using DTS, SSIS, BCP to import data from different sources of data into SQL Server Databases
• Involved Data Modeling using Toad Data Modeler and Designed Logical Physical Database, E-R Diagram
• Involved in Backward Forward Engineering using different data modeling tools
• Involved in creating and modifying tables, Index Cluster/Non-Cluster , Constraints, Views, Stored Procedures, Triggers

Environment: ASP, Java, MS SQL Server, Windows Server, Oracle, MS Access, DTS