SUMMARY

• 7+ years of experience in SQL Server Database Administration, System Analysis, Design, Development & Supporting MS SQL Server’s 2000/ 2005/2008/2008 R2/2012 in production / development / testing, Replication & Cluster Server Environments, SSIS, SSRS.
• Good Knowledge of Relational Database Management System (RDBMS).
• Experience working Windows Server 2012/2008/2003/ NT Server and Installation.
• Experience with MS SQL Server /2005/2000 and their Installation, Configuration and Maintenance.
• Experience in Data Migration from MS SQL server /2008/2008 R2/2012.
• Implemented backup policy using Full, Differential, Transactional log and Recovery and Disaster Recovery Procedures.
• Good Administration skills back up strategies, Model (Full, Bulk logged, Simple), Database creation, Table, Indexes.
• Extensively worked on Stored procedures, Functions, Triggers and Indexes, Views, Cursors.
• Maintaining and Performance Tuning large Databases, Indexing, and monitoring SQL Server using Database Tuning Advisor, SQL Profile (dead locks/ long running queries), Windows Performance Monitor and Database Consistency Check using DBCC Utilities.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008,2008R2,2012 databases.
• Experience in transforming data from different sources like Oracle, Excel, Flat file, Sybase to MS SQL Server by using BCP, DTS, Bulk Insert and SSIS.
• Extensive experience with data modeling, dimensional modeling, logical and physical database design.
• Automated process by creating jobs, maintenance plans and error reporting using Alerts, SQL Mail Agent.
• Experienced in Table Partitioning.
• Involved in Security Administration in creating Schemas, Logins, Users, Roles, granting permissions.
• Data extraction, translation and loading (ETL) using DTS from a wide range of sources Excel, flat file, DB2 and Oracle.
• Implemented different types of Replication Models, Database Mirroring modes and Clustering environments (active/passive and active/active) to further increase scalability and stability of business critical systems.
• Maintained the Security on multiple servers and multiple databases with Windows authentication and SQL authentication.
• Exposure to .NET Framework (V3.5, V3.0, 2.0)
• Expert in Designing, testing and implementation of high availability solutions of databases for large, medium and small customers.
• Experience in implementing and configuring various RAID 1 - 5 & 10 technologies.
• Expert in Creating, Testing and Implementing SSIS packages.
• Experience in developing reports using SQL Server 2008/2005 Reporting Services (SSRS).
• Being proactive in solving performance related issues by monitoring Database Growth, Documenting of server setting and all the configuration changes, health of databases and the hardware utilization.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in DB.
• Possesses a solid understanding of object oriented design and analysis for enterprise wide client/server and Internet application.
• Excellent written, analytical and interpersonal communicational skills accompanied by good documentation and testing skills. Exceptional ability to quickly grasp and master new concepts and technologies.
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Worked 24 x 7 for production support with multiple SQL Instances.

TECHNICAL SKILLS

Database: SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 8.0/8i, MS-Access.

BI/ETL: SSIS, SSRS.

Reporting Tools: Crystal Reports and SSRS

Languages: TSQL, PL/SQL, Java, HTML, XML, VB, ASP.NET, VB.NET, C#, C, T-SQL, PL/SQL, MDX

Web Design Tools: Dream Weaver, FrontPage

Database Design Tools: ER Win, MS Visio

GUI: Visual Studio.NET, VB6, Visual Studio 2008

Operating Systems: Windows 2003/2008 R2/2012, Windows 95/98/XP/7, Mac.

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

SQL DBA and Developer

Responsibilities:

• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Backup and recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Creating databases and logins and users with permissions in SQL server 2008/2008R2/2012.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from DB2 and Oracle to SQL databases.
• Creating SSIS packages using ETL tools to migrate data from different source.
• Creating database Maintenance plans using SSIS and DTS packages.
• Scheduled Full, Differential and Transactional log backups for the user created and system databasesin the production environment using the Database Maintenance Plan Wizard.
• Deploying SSIS packages, and creating and scheduling SQL Server Agent jobs, and modifying whenever error occurs.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services (SSRS 2005) that included paper-based and interactive web-based reports.
• Creating and deploying adhoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
• Developing and re-deploying reusable reports by passing Parameters based on business needs
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Performed Backup and recovery & Automation of Backups using maintenance plans.

Environment: Windows XP, SQL Server 2012/2008R2/2008/2005, DB2, Oracle SQL developer, SSIS, SSRS, TSQL, SQL Profiler, DTS, Visual Source Safe (VSS).

Confidential, Dallas, TX

SQL DBA and Developer

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008/2008R2/2012 in Production and test Environments.
• Involved in Data modeling, designing, and building relational databases.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering, Replication.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Backup and recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008/2008 R2/2012.
• Created Linked Servers between SQL server 2005/2008/2008 R2/2012 and Oracle servers in the environment.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
• Configured Snapshot and Transaction Replication.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services (SSRS 2005) that included paper-based and interactive web-based reports.
• Created adhoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Performed De-fragmentations Techniques of most complex indexes.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created SSIS packages using ETL tools to migrate data from different source.

Environment: Windows 2003, SQL Server 2008R2/2008/2005, SSIS, SSRS, TSQL, SQL Profiler, DTS, Visual Source Safe (VSS), LiteSpeed.

Confidential, Detroit, Michigan

SQL DBA\Developer

Responsibilities:

• Installation, configuration and Administration of MS SQL Server on Windows2003 Servers.
• Logical and Physical design of database for projects on basis of user requirement.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Implemented and maintained database security, logins, roles and schemas.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Performed Database backups (operating system, flat file backups & export/import).
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Implement Replication for Data across different Instances of the application.
• Worked on Active/Active and Active/Passive Clustering.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse

Environment: SQL Server 2000/2005, T-SQL, MS Reporting Services (SSRS), SSIS, Windows 2003 Server, Erwin

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Administrator tasks such as managing users, roles and profiles, Implemented and maintained database security.
• Performed Database backups (operating system, flat file backups & export/import).
• Configured Various Replication Types between Primary Server and Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2000/2005 Environment to Test the Software.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Checked databases, jobs, nightly backups on all servers and monitor system log and security log on Event Viewer.
• Successfully loaded data from EXCEL, Access into SQL Server database Table.
• Created database snapshots and stored procedures to delta load data from the snapshot database to the report database
• Timely completion of activities for database backup, restoration and health check of databases.
• Monitoring Log shipping/Replication and trouble shooting of errors.
• Established and documented a complete Disaster Recovery Plan for the Database servers.
• Configured the SQL Server’s Optimal Settings (Multithreading, Locking Memory) according to the usage of its tables, # of users and hardware.
• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Interaction with programmers and fulfill their requirements
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Developed ETL packages to load data from OLTP to OLAP databases by performing various transformations using Script Component, lookup, Cache transform, Conditional Split, Data Conversion etc.
• Used Erwin for dimensional data modeling.
• Generated different kinds of reports using SSRS with data source as either OLTP or OLAP databases.
• Involved in creating SSIS packages to perform ETL tasks to load data from Flat files into data warehouses and creating dimensional and fact tables.
• Involved in creating SSIS packages to perform ETL tasks to load data from Flat files into data warehouses and creating dimensional and fact tables
• Provided 24/7 Supports for production, Development & Test Servers of MSSQL Servers.

Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, Windows Server 2003, Visual Studio 2003, .Net Framework 2.0, Erwin

Confidential

MS SQL SERVER DBA

Responsibilities:

• Design the optimum data movement strategies for receiving data from different investment Departments and Agencies as well as from Winward itself.
• Development of T-SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
• Administration of around 25+ SQL server 2005/2000servers. Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Developed DTS packages and schedule jobs for loading data between different sources.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Created Views and Index Views to reduce database complexities for the end users.
• Code Review for different modules of SQL Technology Team.
• Implement Replication for Data across different Instances of the application.
• Installation of SQL server Instances and Service Packs. Applying Hot Fixes. Testing and analyzing effects of Server Upgrades and Security Fixes on customized server instances with Mount Points etc. Implementation of new changes through Change Request.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Documented disaster recovery plans and participated disaster recovery drills.
• Reviewed third party tool (Idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Performed query tuning, assigned proper Indexes for better performance.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: SQL Server 2000/7.0, Transactional- Sql, Windows 2000 data center/advance server, IIS 6.0 and Crystal reports 8.0, dell power edge 6650, Third party tools (Idera diagnostic tools, Lumigent log explorer.