SUMMARY:

• 8+ years of IT experience as SQL Server 201 2/ 2008/2005/2000 Production / Application DBA, T - SQL & BI Developer
• Installed, configured and maintained standard and enterprise editions of SQL Server 2008 R 2/ 2008/2005/2000
• Successfully upgraded SQL Server 2000/2005 databases and reports to SQL Server 2008/2008 R2
• Developed and maintained various complex T-SQL, Powershell scripts for various DBA related tasks
• Managed, developed and troubleshooting DTS/SSIS packages and SSRS reports
• Resolved Job failures, backup failures, database integrity. Fixed connectivity issues of SQL Server and Report Server
• Improved performance of production server by Performance Tuning, Query Optimization and managing Indexes.
• Troubleshooting complex issues using Performance Monitor, SQL Profiler and Dynamic Views
• Monitoring and maintaining Sharepoint 2007/2010 and BizTalk 2010 environment.
• Managed, Monitored thousands of databases and 400+ SQL servers in 24/7 environment
• Experience in configuring, monitoring and troubleshooting Active/ Passive Clustering
• Experience in Linked Servers and linking different databases like MS Access, Oracle
• Setting up Maintenance Plan, SnapManager tool for regular, automated and independent set of Backups
• Experience in setting, managing and troubleshooting issues with Snapshot, Merge and Transactional Replication
• Developed Disaster Recovery plans using Log Shipping, Database Mirroring, Restored backups regularly for verification
• Experience with LDAP, handling Active Directory data using SQL Server
• SQL Agent to set up various Jobs for automation, Windows Scheduler to run batch files with bcp commands
• Implemented SQL server monitoring using Database Mail, Alerts and Operators
• Secured and audited data using Change Data Capture (CDC) and SQL Server Auditing in SQL Server 2008
• Implemented various functionalities using Triggers, Functions and Stored Procedures in T-SQL
• Developed and maintained databases for various custom applications and reports .NET and Java developers
• Developed applications using Microsoft Windows Servers and maintained servers using Event Viewer
• Experience in Data Warehousing, writing complex MDX queries, SSAS for creating cubes
• Created E-R diagrams and data models using ERWIN tool, MS Visio 2007
• Provided support for LINQ & CLR Assemblies, stored procedures and functions
• Security management using Roles and Groups in SSMS, SSRS and SSAS
• Developed reports on Oracle BI Discoverer Tool, Everest (an ERP tool) and Pac2000 system
• Managed data in Banking as well as Healthcare industries by using encryption techniques in SQL Server 2005/2008
• Experience in installing, configuring and maintaining of BizTalk Server 2006 and Visual Studio 2005/2008

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008/2008 R2, 2005, 2000, MS-Access, Oracle, My SQL 5.0, MongoDB

Servers/Systems: Windows2008 R2/2003/2000/XP/Vista (32 bit/64 bit), MS DOS, UNIX, Linux, Project Server 2010

Programming skills: T-SQL, Common Language Runtime (CLR), language-integrated query (LINQ), MDX, PL SQL, Java,.NET, XML, C, C++, Perl, Cold fusion, Sublime

SQL Server Specific Tools: SQL Server Management Studio, SSRS, SSAS, SSIS, DTS, Business Intelligence Development Studio, Visual Studio 2008/2005, DataDiff

DBA Tools: SnapManager, Performance Monitor, SQL Profiler, Database Engine Tuning Advisor, SQL Server Agent, SQLH2Tool (Microsoft), Microsoft Baseline Security Analyzer, Idera SQL Diagnostic Manager, Red Gate Backup Tool, Commvault Backup Tool

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Installed, configured various editions of SQL Server 2012/2008 on multiple servers
• Installed Oracle 11g Client on all newly installed SQL Servers
• Assisted in installing, maintaining and monitoring LogShipping
• Maintained, migrated and troubleshooting of database mirroring
• Migrated various 2000/2005 databases to 2008.
• Performance Tuning using indexes, SQL Profiler, Database Engine Tuning Advisor and system views.
• Troubleshooting critical performance, space, availability and various issues using TSQL/Powershell
• Developed and enhanced full backup, transaction log backups and purge backup jobs on around 250 servers.
• Maintained the Database refreshing till the end of cut over of the project
• Developed script to find out missing Full and Transaction Log backups on all production servers
• Daily monitoring and fixing issues related to backups, jobs and other SQL Server related issues
• Deployed various scripts for thousands of databases on multiple servers through ticketing system
• Resolved various issues for Report Server
• Installed and configured around 40 SQL Reporting servers.
• Maintained analysis services on all SQL Servers where it is installed.
• Resolved various issues related to SQL Cubes.
• Developed scripts to maintain updated SQL Server information centrally
• Changed service accounts on 400 plus SQL Servers and resolved multiple issues using T-SQL scripts

Environment: Windows Server 2012/ 2008R2/2008/2003, SQL Server 2012/2008 R 2/ 2008/2005/2000 (64bit/32bit), SSIS, SSRS, SSMS, Enterprise Manager, LiteSpeed, CommVault

Confidential, Phoenix, Arizona

SQL Server DBA/Developer

Responsibilities:

• Installed, configured various editions of SQL Server 2012/2008 on multiple servers
• Assisted in installing, maintaining and monitoring Active/Passive SQL Server 2008 cluster
• Creation & Migration of various DB Objects like Tables, Primary Keys, Foreign Keys, Indexes, Stored Procedures, functions across multiple environments
• Implementation of Backup and Recovery methodologies involving Full, Differential and Tranlog backups across Production, UAT and Development servers
• Migrated logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server 2000 2005 on Development, Testing Production Environments for various mission critical applications. Upgrade DTS Packages to SSIS Packages
• Experience in Designing and Data modeling logical/Physical Designs using ERWIN, Database Diagrams etc and Reverse/Forward engineer the data models
• Monitored database performance on tables using Index tuning Wizard and rebuilt indexes to reduce fragmentation using DBCC DBReindex, Indexdefrag, AlterIndex
• Involved in Microsoft Project Server Migration
• Implemented Native SQL Multi Server Administration
• Development of automated daily, weekly and monthly system maintenance tasks.
• Created jobs, alerts and monitor, activity logs, error logs to capture and fix any possible errors
• Created Linked Servers across various data sources including SQL Servers, Oracle.
• Configured MS SQL Server 2005 in-built log shipping from primary server to standby server for report generation.

Environment: Windows Server 2008R2/2008/2003, SQL Server 2012/2008 R 2/ 2008/2005/2000 (64bit/32bit), SSIS, SSRS, SSMS, Enterprise Manager, LiteSpeed

Confidential, Phoenix, Arizona

SQL Server / Oracle DBA

Responsibilities:

• Involved in administration of MS-SQL Server version MS SQL 2000 / 2005/2008/2012 across different environments
• Performed security configuration, user administration tasks like managing users, roles, and profiles
• Performed Database backups (operating system, flat file backups & export/import)
• Created DTS /SSIS Packages for data transformation.
• Used the MS Reporting services to created, schedule and publish the reports required
• Configured and used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Successfully Implement the 2 Node Active\Passive Clustering for two different production applications.
• Job Monitoring and making sure all jobs run successfully.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Provided 24*7 support to SQL application developers in implementing the applications on production server.
• Established and documented a complete Disaster Recovery Plan for the Database servers
• Created development scripts, including rollback scripts, for all SQL Server changes
• Created Crystal Reports for Business Intelligence
• Monitoring MYSQL databases on daily basis.
• Maintaining Backups of master and slave servers of MYSQL with the backup scripts.
• Tuned SQL Server performance using SQL Server Profiler and Execution Plans.
• Developed and enforced organizational SQL standards and best practices
• Evaluated new releases of operating systems and database management software (DBMS) and suggested processes for migrating to new releases
• Install, Configure Oracle 10g, 11g RAC with ASM on Linux(Red Hat), Unix systems
• Configure physical & logical standby databases using Oracle Dataguard for disaster recovery
• Switch over and fail over of Oracle dataguard databases for Disaster recovery testing using Oracle Dataguard broker DGMGRL
• Configure, monitor table level and schema level Oracle streams replication with negative rules to avoid the deletion of data
• Configure, Manage, and monitor RMAN backups (Cold Backups, Hot Backups)
• Refresh the test environments with Production data using RMAN duplicate & Data pump
• Performance tuning of the Oracle databases and SQL queries by analyzing the EXPLAIN PLAN ‘s to improve the performance of the database and application end users
• Interact with the development teams regarding the code migrations from QA to Prod
• Configure the databases using BMC Patrol and OEM Grid Control for monitoring
• Manage tickets generated through   ticketing system   SAP CRM and work till Resolution
• Migrating databases using file system to ASM with no impact/downtime to customers
• Capacity planning of the databases to increase the size of the ASM disk groups
• Prepare standard documents for the Oracle cluster ware installation and data refreshes
• Participate in 24*7 on-call rotation schedule and take care of issues during after hours
• Patch the CRS, ASM, RDBMS and 11g Grid Infrastructure homes using OPatch utility
• Interact with Storage team, Network team, Sysadmin team to get the prerequisites fulfilled for RAC installation
• Identify and fix database block corruption by restoring the data from the recent backups
• Upgrade the Oracle databases from 9i, 10g to 11g using DBUA and manual process
• Interact with My Oracle Support regularly regarding open Service Requests
• Involve in deployment meetings before application new/upgrade Releases
• Rename the Oracle ASM disk groups using RENAMEDG command in 11gR2
• Restore the databases, datafiles, tablespaces from the backups in case of any data loss
• Participated in application development process and code reviews of database objects
• Generation of SQL Server Storage Reports
• Maintaining Daily Check Lists
• Solving the production issues using HPSM
• Experience in capacity planning. Created custom SSRS reports to track the Database growth and volume changes on periodic basis.
• Worked with various teams for technology upgrades (.Net, IIS 7, PowerBuilder, Power Logic, SDE GIS, Windows Server 2008
• Worked with Security/Firewall teams to open specific ports for SQL Server monitoring
• Created jobs, alerts, Schedules and monitor activity logs, error logs to capture and fix any possible errors.
• Configured MS SQL Server 2005/2008 in-built log shipping from primary server to standby server for report generation.
• Experience with RAID levels and SAN storage infrastructure.
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup, archival software, media, hardware, and offsite storage.
• Configured Various Replication Types between servers, with separate Distributor server and experience in troubleshooting replication issues in MS SQL Server 2000/2005 Environment to Test the Software.
• Extensively worked on DB Programming using T-SQL in developing stored procedures, Views functions and BAT Scripting.
• Developed various Reports using SQL Server reporting services (SSRS 2005/2008)
• Monitoring Blockings and Proactively monitor Deadlocks and resolve them by setting up trace flags - T1204,1205,T1222
• Involved in Designing and Data modeling logical/Physical Designs using Database Diagrams.
• Involved in extensive in 24/7 production support and assisted end user in testing application functionality.
• Assisted application users with migration/up gradation/testing of different Power Builder, .NET and GIS Spatial ( ArcSDE) Applications
• Worked with SQL Server Profiler, PSSDIAGs and other monitoring tools to generate traces and trouble shoot issues
• Helped Development Team in deploying and testing the application, which uses SQL Server 2000/2005/2008 as backend

Environment: MS SQL Server 2012/2008/ 2005/2000/7.0 , IIS 5.0/6.0/7.0, T-SQL, Windows NT/ 2000/2003/2008 , Litespeed, SpotLight Enterprise, DBDiff, SQL Compare, PowerShell, SQL Server Reporting Services (SSRS 2005/2008), MS XML, Active Directories(ADSI), VBScript, JavaScript, DTS/SSIS,, Visual Studio 2005/2008, HPSM, Idera, SSIS, DTS, Oracle 10g/11g, Red Hat Enterprise Linux 4/5,Oracle 10g/11g RAC,  Windows NT, Database Tools/Utilities, Enterprise Manager, AWR, ADDM, TKPROF, Explain plan, STATSPACK, RPR, ControlM, Sitescope, MySQL, Idera, SQL DM, Red Hat Enterprise Linux 4/5, Windows NT, Oracle 10g/11g RAC with ASM, Oracle Physical standby Dataguard, Oracle Streams, Oracle Database Tools/Utilities, Oracle Enterprise Manager grid control, BMC Patrol, AWR, ADDM, TKPROF, Explain plan, MSSQL, Erwin, Toad, SQL developer, HP service Manager, HP Openview for Operations, Splunk monitoring

Confidential, Milwuakee, WI

DBA/ Developer/ BI Developer

Responsibilities:

• Installation& Configuration of SQL Server 2008/2005/2000 on Dev, Test and Production environments
• Creation and Configuration of SQL Databases including striping VLDB’s (400GB) across multiple files and file groups (Data files, Log files, Index files)
• Security Administration (adding logins, users, granting permissions thru roles, managing schemas) on the SQL Server
• Creation & Migration of various DB Objects like Tables, Primary Keys, Foreign Keys, Indexes, Stored Procedures, functions across multiple environments
• Implementation of Backup and Recovery methodologies involving Full, Differential and Tranlog backups across Production, UAT and Development servers
• Migrated logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server 2000 2005 on Development, Testing Production Environments for various mission critical applications. Upgrade DTS Packages to SSIS Packages
• Experience in Designing and Data modeling logical/Physical Designs using ERWIN, Database Diagrams etc and Reverse/Forward engineer the data models
• Monitored database performance on tables using Index tuning Wizard and rebuilt indexes to reduce fragmentation using DBCC DBReindex, Indexdefrag, AlterIndex
• Involved in Microsoft Project Server Migration
• Implemented Native SQL Multi Server Administration
• Development of automated daily, weekly and monthly system maintenance tasks.
• Created jobs, alerts and monitor, activity logs, error logs to capture and fix any possible errors
• Created Linked Servers across various data sources including SQL Servers, Oracle.
• Configured MS SQL Server 2005 in-built log shipping from primary server to standby server for report generation.
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup, archival software, media, hardware, and off site storage.
• Configured Various Replication Types between servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2000/2005/2008 Environment to Test the Software.
• Extensively worked on DB Programming using T-SQL in developing stored procedures for generating various Reports using Sqlserver reporting services (SSRS 2000/2005)
• Monitoring Blockings and Proactively monitor Deadlocks and resolve them by setting up trace flags - T1204,1205,T1222
• Worked with SQL Server Profiler, PSSDIAGs and other monitoring tools to generate traces and trouble shoot issues
• Involved in extensive in 24/7 production support and assisted end user in testing application functionality.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2000/2005 backend.

Environment: MS SQL Server 2008R2/ 2005/2000/7.0 , Windows NT/2000, MS IIS 5.0, BizTalk 2000 Server, Project Server 2003/2007/2010 , Sharepoint 2007, T-SQL,XML,LDAP, Active Directories(ADSI), SQL Litespeed, BMC Patrol, SpotLight, DBArtisan, SQL Compare and T-SQL, VBScript, JavaScript, DTS/SSIS

Confidential, Milwuakee, WI

DBA/ Developer/ BI Developer

Responsibilities:

• Involved in administration of MS-SQL Server version MS SQL 2000 / 2005 / 2008 across different environments
• Performed security configuration, user administration tasks like managing users, roles, and profiles
• Performed Database backups (operating system, flat file backups & export/import)
• Created DTS /SSIS Packages for data transformation.
• Used the MS Reporting services to created, schedule and publish the reports required
• Configured and used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Successfully Implement the 2 Node Active\Passive Clustering for two different production applications.
• Job Monitoring and making sure all jobs run successfully.
• Involve in Capacity planning for Spatial data databases
• Involved in Microsoft Project Server Migration
• Implemented Native SQL Multi Server Administration
• Take care of tickets generated by BMC Remedy ticketing system
• Maintain the SVN Repository for Java/Database(PL/SQL) code changes
• Monitor ASM storage by creating and dropping diskgroups, adding and dropping disks
• Install Oracle database client on application users computers and application servers
• Apply CPU/PSU patches
• Interact with Oracle Support regarding open Service Requests
• Assist scientists with database usage
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Provided 24*7 support to SQL application developers in implementing the applications on production server.
• Established and documented a complete Disaster Recovery Plan for the Database servers
• Created development scripts, including rollback scripts, for all SQL Server changes
• Created Crystal Reports for Business Intelligence
• Tuned SQL Server performance using SQL Server Profiler and Execution Plans.
• Developed and enforced organizational SQL standards and best practices
• Evaluated new releases of operating systems and database management software (DBMS) and suggested processes for migrating to new releases
• Participated in application development process and code reviews of database objects

Environment: MS SQL Server 2008R2/ 2005/2000/7.0 , Windows NT/2000, MS IIS 5.0, BizTalk 2000 Server, Project Server 2003/2007/2010 , Sharepoint 2007, T-SQL,XML,LDAP, Active Directories(ADSI), SQL Litespeed, BMC Patrol, SpotLight, DBArtisan, SQL Compare and T-SQL, VBScript, JavaScript, DTS/SSIS

Confidential, NY

Developer/ Report Analyst

Responsibilities:

• Installing MS SQL Server, Business Intelligence Studio configuration
• Using the Data Transformation tasks like bcp, BULK INSERT to import/export data from clients.
• Experience in using Oracle BI Discoverer Tool and Pac2000 system
• Building, Managing and performance tuning of SQL database
• Linking SQL Server database to Access database in order to create forms, store and modify data
• Using SSIS for ETL data from raw files to SQL Server database
• Using SSRS for generating reports as an improvement over previous methods used.
• Improvement in queries used on Pac2000 system for generating reports into Excel format
• Using new Oracle Discoverer Tool to pull and store data in raw file format
• Loading data from raw files into SQL Server 2005 and creating relationships between tables
• Writing complex stored procedures for creating finance reports using Crystal Reports XI and optimize the performance of Production Databases
• Performance tuning of the stored procedures and T SQL queries running on the production server
• Gathering requirements from directors of the company and create reports
• Creating reports by installing, maintaining and learning Crystal Reports XI independently
• Everest ERP tool to study and modify E-R diagram

Environment: SQL Server 2000/2005/2008 , MS Access 2003, Microsoft Management Studio 2005, Business Intelligence Development Studio for SSIS, SSRS and SSAS, Oracle BI Discoverer Tool, Windows 2003 Server, Visual Studio 2005, TSQL, Crystal Reports XI, Everest ERP

Confidential,

Junior SQL DBA /SQL Server Developer/ Report Analyst

Responsibilities:

• Employing backup strategies and recovery techniques to ensure the proper functioning and consistency of the databases.
• Snapshot Replication set up and configuration of the databases.
• Performing optimization of indexes and queries and using index tuning wizard to enhance the performance.
• Managing real time monitoring tools for SQL server activities.
• Performing database activities such as data modeling, database design, data analysis, validation and consistency check.
• Maintaining the consistency of the databases using triggers and constraints.
• Using DTS packages to perform ETL tasks
• Using bcp to Bulk Copy and Bulk Insert data
• Implementing business logic, helping developers create business tools using stored procedures.
• Maintained security by creating logins, roles and assigning permissions
• Created database for the company using SQL 2000/7.0 and MS-Access
• Using ER diagram and MS-Visio to design the basic database diagram
• Creating database objects like triggers to enforce data integrity
• Proper use of Indexes to enhance the performance of individual queries and the Stored Procedures
• Installing MS SQL Server, configuration and doing performance tuning, capacity planning, query optimization
• Responsible for Drops i.e. moving from development to QA and then to Production
• Writing migration scripts and taking care of efficiency
• Testing and integrating the scripts, creating unit test plans
• Performing various DDL changes in order to improve performance of database
• Writing stored procedures for generating reports using SSRS 2005
• Writing many new Stored Procedures and modifying existing ones, both in an optimized fashion
• Monitoring the database assigned for development work
• Evaluated SQL Server 2005 including installation, configuration, management, migrating existing applications/servers
• Developed new DTS packages on SQL 2000 and upgraded them to SSIS programs for SQL Server 2005 later on
• Expertise in handling system issues and fixing the same
• Extensive use of Profiler in detecting Production bugs
• Developed Stored Procedures as well as new tables/table changes as required by team/front-end developers

Environment: Windows 2000/2003 Server, SQL Server 7.0/2000/2005 , SSIS, Business Intelligence Tool 2005, Microsoft Management Studio 2005, Visual Studio 2005, DTS, TSQL, Visual Basic 6.0, MS Access, MS Visio