SUMMARY

• Over 8+ years of IT experience in SQL SERVER Database Administration, System Analysis, Design, and Development & Support in Production, QA, Replication and Cluster Server Environments.
• Experience in installation and configuration of MS SQL Server 2012/2008 R2/2005/2000 versions.
• Experience in Migration from SQL Server 2000 to SQL Server 2005/2008 R2/2012 and Oracle 11g as well as DTS Exchange tool for migrating DTS packages to SSIS packages.
• Installed and created SQL Server software and databases on Windows servers.
• Strong noledge Database Design & Architecture principals.
• Exposure to Oracle programming and Architecture.
• Experience in working with windows server 2003 and 2008.
• Experience in up gradation/Migration of MS SQL Server 6.5/7.0 to MS SQL Server 2000 and now and 2008 by in place upgrade process and Side by Side process
• Experience inmigration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Installing SQL Server in a Cluster Environment.
• Expertise in planning and implementing MS SQL server security and database permissions
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Extensive experience with Storage Capacity planning, including system storage allocation, on - going capacity analysis and planning future storage requirements.
• Experience in IIS, MTS, and Windows NT administration.
• Experience with upgrades and service pack installations Tuning and normalization.
• High-level proficiency with various types of Replication Models such as Snapshot, Transactional and Merge Replication (Planning, Replication Tools, Implementing Replication).
• Extensive experience in Capacity planning, Maintenance planning, Performance Tuning.
• Proficient in monitoring SQL Server Performance using SQL Profiler (Dead Locks/Long running queries), Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard and Windows Performance Monitor.
• Extensive noledge of Relational Database Management Systems.
• Hands on experience and outstanding noledge in high availability solutions, including SQL Server clustering, replication, Log shipping, and Mirroring.
• Managed teh multiple databases (DB) under clustered (active/active, active/passive) and implementing RAID technology.
• Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment.
• Good experience in monitoring Windows and SQL Server error logs.
• Experiences in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC, resolve Dead Locks/Long running queries.
• Managed and working experience with teh RAID LEVELS.
• Strong SQL Server Administration skills using various backup strategies, Model (simple, bulk and full), database maintenance plan, user (NT/SQL) security authorizations, database creation.
• Very good hands on experience with DB Artisan admin tool and SQL Assistant tool.
• In depth noledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views using SSMS and SQLCMD.
• Hands on experience on working with Sybase version 12.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers through query analyzer
• Design entity relationship diagrams and dimensional data models.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.
• Supported teh deployment of SQL Server 2005/2008, SSAS (Analysis Service), SSRS (Reporting Service) and SSIS (Integration Service for ETL activities).
• Self-motivated and Flexible to adapt to any new environment and work on any project.
• Worked as a team member to provide 24x7 on-call production database support.

TECHNICAL SKILLS

Relational Databases: SQL Server 20122008R 2/2005/2000/7.0 , MS-Access 2000/2003/2007 , Oracle 9i & 10g, My SQL 4/5

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: C, C++, C#, JAVA, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL.

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate, SQL COMPARE, lite speed.

PROFESSIONAL EXPERIENCE

Confidential, Fortworth TX

Senior SQL Server Production DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2)/2012 on Test, Development and Production Environments.
• Migrated teh data from SQL Server 2000/2005 to SQL Server 2008 and 2012.
• Involved in teh complete lifecycle and capacity planning of mission critical Databases.
• Scheduling SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages, using DTS upgrade wizard.
• Generating Reports as per teh requirement using SSRS 2005, 2008 and 2012.
• Involved in evaluating performance monitoring tools like IGNITE, FOGLIGHT, SQL SENTRY and involved in installed them to monitor teh production servers.
• Responsible in developing stored procedures for rebuilding and reorganizing indexes based on fragmentation levels as a part of database maintenance.
• Replaced a transaction log replication with mirroring on a report server and took reports from snapshots of teh mirror database.
• Increased teh availability of production databases by setting up mirroring.
• Involved in setting up maintenance plans using Light speed for taking backups on daily basis.
• Involved in maintaining and administration of IIS server and SSRS servers.
• Highly involved in performance tuning, query optimization and evaluating teh performance of production servers and suggesting recommendations and implementing best practices.
• Involved in Writing DTS as well as SSIS packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for teh Data Migration team. Also upgraded DTS packages to SSIS.
• Conducted root cause analysis of application availability and narrow down teh issues related to coding practices, database bottlenecks, or network latency.
• Implemented Security, which included creating Logins, Users and granting permissions to users.
• Managing security roles in SQL Suite & Install updates and patches.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSAS,SSRS,ReportBuilder,Lite Speed, Ignite, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, JDA Software Dallas TX

Sr. SQL Server Production DBA

Responsibilities:

• Responsible for installing and maintaining SQL Server production 2012 databases for more TEMPthan 100 clients.
• Responsible for importing DTS packages into 2008 environment and setting up scheduled jobs to run teh packages.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL in .
• Involved in migration of databases from one datacenter to another datacenter and also databases from SQL Server R2 /2012.
• Involved in changing and migrating teh entire code from sql server 2005/2008R2 to 2012.
• Responsible for developing new stored procedures, functions and other database objects in 2012 edition of SQL server.
• Implemented teh new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Involved in design and development of teh smart reindexing procedures for maintenance for all clients in SQL Server .
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for teh organization to ensure consistency in database and code development.
• Implemented a performance tool called IGNITE for proactive monitoring of databases and servers. Debugged performance issues using teh tool.
• Responsible for handling over 1000 Production instances and 500 non production instance.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Responsible for setting up Transactional replication and database mirroring on production servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Responsible for moving big data files using ROBO COPY.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Responsible for development of SSIS packages for ETL.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/ 2008R2 and 2012.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Checking Database Health by using DBCC Commands.
• Monitored and modified Performance using execution plans and Index tuning.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Restored Databases frequently into QA/ Dev. environment based on teh requests coming in.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Provided 24/7 Server support as needed.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSAS,SSRS,ReportBuilder,Lite Speed, Ignite, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining teh database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for teh organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2005 to SQL Server 2008R2/2012.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote teh reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for teh Disaster Recovery plan
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSAS,SSRS,ReportBuilder,Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, Tampa, FL

SQL Server DBA

Responsibilities:

• Installed and configured SQL server 2008 and administered 100+ servers with zero downtime
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of teh existing schemas
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Administered teh SQL server 2000/2005/2008 by creating user logins, dropping and locking teh logins, monitoring teh user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to teh database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Experience involving in SOX and SAS auditing.
• Experience in handling teh situations in change control process.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Experienced working on SQL COMPARE tool to compare teh structures between databases in order to synch them
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers.
• Installing SQL Server 2008 in windows Cluster environment.
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003 servers.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Involved in migrating database from oracle 11g to SQL server 2008.
• Actively involved in data warehousing of teh Sybase database onto SQL SERVER 2008.
• Experience with Dropping and recreate teh tables for teh damaged databases to avoid data loss.
• Refresh teh database from production to development and staging environment on daily basis.
• Experience in working with Semantic client management.
• Developed physical data models for database schema and objects.
• Experience in handling creating snapshots and Subversioning, ClearCase/SVN SQL Server.
• Involved in teh Backup & Restore and point in time recovery of teh databases.
• Responsible for developing, monitoring and deploying SSIS packages.
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed
• Used Lookups Transformation to get teh data from data sets.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring teh performance of SQL Server databases.
• Involved in teh Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Write SQL views against source tables in Oracle with business rules applied.
• Created permanent tables, temporary tables and table variables.
• Responsible for handling in high available clusters such as fail over clusters.
• Hands on experience on working with Sybase version 12.
• Conducted design reviews with users/team for development and production strategies.
• Experience in handling in SOA environment.
• Translating business requirements into technical design specifications and actively supported business users for change requests.
• Developed DTS and SSIS packages to extract, transform and load (ETL) teh data using SQL Server 2008 Integration Services and successfully completed DTS to SSIS conversion
• Capacity-planning, Maintaining run book documentation on all teh servers in word, PDF and excel formats.
• Good experience in handling onsite-offshore model.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2008 R2/2005/2000, Windows 2000, Windows NT,RDBMS, lit speed, SQL backup5, SQL secure, Sybase, Clustering, ETL, SSIS, SSRS, C#., VB,ASP.NET, Replication, MS Excel and MS Access, Sybase, Oracle, UNIX, SSAS, System Monitor / Performance Monitor.

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Installing and Configuring SQL Server 2008/2005/2000 and administration of nearly 120+ servers ensuring zero downtime.
• Upgraded teh existing database to SQL Server 2008/2005 from SQL Server 2005/2000.
• Installed and managed MS SQL Server Cluster Server and configured SQL Server 2000 on Windows 2000 Advanced Server.
• Designed Logical and Physical database design using Diagram feature in SQL Server and Created teh Physical Database design for production database.
• Developed objects by creating COM Components using VB and IIS technology.
• Experience in working with HIPAA and HL7 dat facilitate teh data between teh applications.
• Moved teh legacy inspection applications data from various heterogeneous sources like Oracle, MS Access, and MS Excel and text files to SQL Server 2000 database using BCP and dynamic DTS packages
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Worked on Table Design, Index Design and Performance Tuning.
• Created and maintained entity relationship diagrams, Meta data repository and comprehensive system documentation.
• Employing indexing strategies and optimizing them using SQL Profiler and Index Tuning Wizard.
• Worked on indexing, fill-factors of data pages, Integrity Checks, Update Database Statistics and Re-indexing.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Worked on UNIX shell scripts for automating scheduled DBA tasks.
• Worked on SQL Server Clusters Active - Active on mission critical financial applications
• Worked on advanced disaster recovery techniques like Standby databases which acts like a failover for our mission critical production databases in financial environment.
• Logical and Physical design of database for projects on basis of user requirements using Erwin.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005
• Created Database Snapshots and stored procedures to delta load data from teh snapshot database to teh report database.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures in T-SQL.
• Migrating SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improving teh performance by designing SSIS packages for parallelism.
• Generating Various Reports using SSRS 2008.
• Actively involved in data warehousing of teh Sybase database onto SQL SERVER 2008.
• Worked on OLAP data Meta Data in MDX, Calculated members, Named sets ofDimensions and writing MDX queries.
• Experience with DB Artisan admin tool as well as VERITAS Netback up.
• Worked on Business rules implementation and Deployment using EJB and Web logic Server
• Created OLAP cubes using analysis services. Configured teh security roles to teh OLAP environment.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables in Oracle and SQL Server.
• Created (SSIS) packages to import data from Flat Files to SYBASE.
• Experience in Creating and Debugging Store procedures, Triggers and Functions in T-SQL.
• Used SQL Profiler for Trouble shooting monitoring optimization of SQL server and production database code as well as T-SQL code.
• Experience involving in SOX and SAS auditing.
• Created SSIS packages from standalone systems to incremental files.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Developed DTS packages to extract, transform and load into teh Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS).
• Experience in designing, building teh dimensions, cubes with star schema using SQL SERVER ANALYSIS SERVICES (SSAS)
• Involved in developing teh data models and analyzing data relationships, storage requirements.
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain teh system 24X7 running.

Environment: Microsoft SQL SERVER 2008/2005, Microsoft Windows 2003/2000/NT SERVER R2, Clustering, SSIS, SSRS, SSAS System Monitor / Performance Monitor, Oracle, Replication, Performance Tuning, DB Mirroring.

Confidential

SQL Server Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Designing and creation of tables and stored procedures with E-R diagrams.
• Writing teh stored procedures, checking teh code for efficiency using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2000.
• Created and maintained various databases for development and testing environment.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers through query analyzer.
• Data Transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
• Using Data Transformation Services (DTS) and SSIS to populate data from various data sources using teh concept of OLE DB.
• Involved in Data warehouse support.
• SQL Server Reporting Service to create enterprise, ad-hock, embedded and web-based reports.
• Testing teh stored procedures performance and its path of execution by using SQL Profiler.
• Recovering teh Backups of production databases as a part of regular maintenance activities.
• Crystal Reports is used to create more flexible, tailored, and responsive report.

Environment: Windows 2000 server, T-SQL, SQL, SQL Server (Enterprise Manager, Query Analyzer), SSIS, SSRS, UML and Visual Basic 6.0, Crystal Reports.