PROFESSIONAL SUMMARY:

• Over 10 years of IT experience on Database Administration and development with MS SQL Server technology.
• Experience in Implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS in SQL Server 2012/2005/2005.
• Hands on experience in Transact-SQL T-SQL Programming.
• Extensive experience with Backing Up, Restoring and Moving of Databases.
• Configuring SQL Server Agent Jobs. Designing Database Security.
• Hands on experience in Installation and Configuration of SQL Server 2012/2008/2005/2000 technology, service packs and hot fixes. Updates rolled-out from Development, Integration, QA and finally Production.
• Experience in SQL database design, architecture, data modeling using Erwin, Data Warehousing and analysis skills, ETL tool with Microsoft Technologies like SSIS/SSRS.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Worked on Data compression methods.
• Expertise in Implementing Database Mirroring and log shipping in SQL Server 2012/2008.
• Ability to create new databases. Capacity Management of SQL Server and Databases.
• Implementing and Managing of Replication in SQL Server 2012/2008/2005.
• Experience working with Change Data Capture of SQL server 2012/Resource Governor.
• Good experience and knowledge on Always ON.
• Ability to Migrate Databases from SQL Server 2000 to SQL Server 2012/2008.
• Expertise in Database Maintenance by using Managing Index Fragmentation. Managing Statistics, Shrinking Files and Using DBCC Commands.
• Expertise in Failure Diagnosis with Database Failures, Physical Server Failures and SQL Server Service Failures.
• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Expert in Disaster recovery Management. Experience in Failover Clustering for SQL Server 2012/2008/2005 Servers.
• Experience in .NET programming, T-SQL, DMO, SMO and WMI for writing automation scripts in SQL Server.
• Clear understanding of Windows Server Events and SQL Server Events.
• Experience in working on storage tuning of file groups, RAID and SAN.
• Hands on experience in Deployment of DTS and SSIS packages using ETL Tool.
• Designing SSIS packages for extraction, transformation and loading of data.
• Configuring SSRS. Generating Reports using SSRS.
• Expert knowledge of client connectivity TDS/TCP/IP packages including ODBC, OLEDB, and JDBC.
• Work with developers to move all dynamic SQL into stored procedures and connection strings into web.config files.
• Able to work independently and collaborate proactively cross functionally within a team.

TECHNICAL SKILLS:

• Databases: MS SQL Server 2012/2008/2005/2000 and Oracle 9i/10g.
• SQL Server Tools: SQL Server Management Studio, SQL Server Profiler, DTS, Replication and
• Mirroring
• Operating Systems: Window 9x, Windows NT, Win 2000, Win XP, Windows 2012/2008/2003 Server.
• Languages: C, C , T-SQL, PL-SQL, C , PowerShell
• Internet Technologies: ASP.NET, HTML, XML, DHTML, VB.NET, JavaScript, Active Server Pages
• ASP
• Web servers: IIS4.0/5.0
• Tools: Red gate, SQL Lite Speed, Legato, Blade logic automation tool, IBM Maximo, BMC Remedy.
• Storage Management: Semantic Netbackup, IBM Tivoli Storage Manager.
• ETL Tool: SQL Server Integration Services.
• Reporting Tool: SQL Server Reporting Services

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. SQL DBA

Responsibilities:

• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Working on production Break fix issues which include performance, blocking and space related issues.
• Providing 16/7 support for critical production databases of Bank of America Datacenters.
• Installed SQL Server 2008, 2012 on hundreds of machines/clusters.
• Worked on Projects to provide DBA support for Building SQL Servers for new applications begin to end support
• Scheduling Jobs and Alerts using SQL MAIL.
• Database Migrations from SQL Confidential
• Configuring SSRS, Deploying and Migrating SSRS reports.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Maintaining USER PERMISSIONS, LOGINS and SECURITY Issues. Monitoring Event Viewers, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Monitoring servers thru Foglight alerts.
• Installing drivers for DB2, Teradata, Oracle, MySQL for Configuring linked servers and Data migration as per line of business requirement.
• Database refreshes on Lower environments.
• Working with Maximo Change Request Any changes in Production database need to Create Maximo Tickets this should be approved by Global DBA team after changes made in stage and development environment
• Creating and scheduling maintenance routines.
• Configuring CLUSTERING, LOG-SHIPPING, MIRRORING, REPLICATION.
• Resolving all high availability Issues.
• Working with development teams to resolve ETL packages errors and deployments
• Create and Modify of the database objects according to the requirement.
• Resolving Database Failures, Physical Server Failures and SQL Server Service Failures
• Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards at Bank.
• Implemented backup and Recovery strategies.
• Release activities including Spec reviews.
• Involved in all ITIL process like Change management, Incident Management Problem Management.

Environment: Windows 2012/2008/2003/2000/NT4.0, MS-SQL Server 2012/2008R2/2008/2005/2000, SSIS, SSRS, System Monitor / Performance Monitor, Foglight, Lite Speed, RedGate, Maximo ,BDA

Confidential

Role: SQL DBA

Responsibilities:

• Administering 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
• Planned and implemented long-term capacity planning and infrastructure changes to maximize performance for all database components.
• Managing databases, tables, indexes, views, stored procedures, enforcing business rules with triggers and user defined functions.
• Automating administration tasks, managing SSIS packages, managing security, monitor server performance and activities.
• Installing and Configuring of new SQL Servers 2008 and 2005.
• Implementing service packs and security vulnerabilities.
• Restoring and copying Production Databases.
• Resolving various performance issues by using DBCC commands, SQL Profiler and NT monitoring tools
• Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
• Responsible for deployment and roll back execution to support software/solution releases.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve data from the Flat files on monthly and weekly basis.
• Up gradation from SQL 2000/2005 to SQL 2008.
• Creating and deploying Tabular, List, Matrix reports using SSRS.
• Plan and Schedule the Online Backups.
• Running Index tuning wizard, implementing Database Mirroring.
• Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
• Import/export data, backup restore database, managing servers and managing clients.
• Managing SQL Server nodes on Cluster.
• Managing backups using Redgate.
• 24/7 On-call support and production support.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.

Environment: SQL Server 2008/2005, Windows Server 2003/2008, Peer-Peer Transactional Replication, Business Intelligence Development Studio, SSIS, SSRS, .NET, Microsoft Exchange Server, AppDetective, SQL Diagnostic Manager, MS Visio 2003.

Confidential

Role: SQL DBA/BI Developer

Responsibilities:

• Responsible for deployment and roll back execution to support software/solution releases.
• Administering 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.
• Installation and Configuration of SQL Server 2008.
• Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
• Database design and data modeling using ER Studio.
• Restoring and copying Production Databases.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve data from the Flat files on monthly and weekly basis.
• Process automation for Tape backup verification, services verification etc. with scripts using VB.net, PowerShell and C .
• Data Upgradation from SQL 2000 to SQL 2005 and to SQL 2008.
• Creating and deploying Tabular, List, Matrix reports using SSRS
• Plan and Schedule the Online/Offline Backups.
• Running Index tuning wizard, implementing Database Mirroring.
• Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
• Import/export data, backup restore database, managing servers and managing clients.
• Automating administration tasks, managing SSIS packages, managing security, monitor server performance and activities.
• Managing SQL Server objects by enforcing business rules with triggers and user defined functions.
• Planned and implemented capacity planning and disk data migrations.
• Managing SQL Server nodes on Cluster.
• Managing backups using Redgate.
• 24/7 On-call support and production support.

Environment: SQL Server 2000/2005/2008, Fail over Cluster, SQL Server Integration Services, SQL Server Reporting Services, Windows Server 2003, Business Intelligence Development Studio, .NET

Confidential

Role: Database Administrator/BI Developer

Responsibilities:

• Hands on experience in understanding Physical and Logical database design.
• Coordinating with different Teams during production releases.
• Implementation of Data Restoration Strategy. Managing SQL Server Permissions.
• Creating Jobs and schedule them for Backup of databases.
• Providing critical production support during upgrade and go-live phase.
• Problem analysis/making proposals for alternative solutions.
• Deployment of DTS packages and configuration of log files.
• Implementing and monitoring of Replication.
• Configuration of Mirroring for High availability of the Databases in SQL Server 2005.
• SQL Server Scripts vetting before deployment in the environment.
• Creating User access, SQL Logins, Roles and Schemas.
• Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Migrating DTS packages to SSIS packages.
• Strong knowledge of Performance SQL Server tuning.
• Generating Reports using SQL Server Reporting Services.
• Hardware resource planning, scheduling and production monitoring.
• Acknowledging SQL Server Alerts in the environment and resolving.
• Document the relationships among the SQL Servers and Databases.
• Using Microsoft SQL Server 2005 Upgrade Advisor for Analysis to Migration of Databases.
• Experience in Extracting Data From XML and flat files using SSIS
• Using Data Flow transformations in SSIS packages.
• Debugging SSIS Packages and managing package execution. Optimizing SSIS packages.
• Provided 24x7 supports to business operational models.

Environment: SQL Server 2000,SQL Server 2005, DTS, ER Diagrams, Erwin, SQL Server Integration Services, Cluster, Windows 2003 Server, MS Access, ASP, MS Reporting Services, HTML

Confidential

Role: Database Administrator

Responsibilities:

• Validated the configuration and performance of the existing databases including data file allocation, index, fragmentation and the impact on system performance. Analyzed potential to avoid and optimize problems like delayed response, locking, server down time, etc.
• Creating new database objects like tables, views, indexes, stored procedures and functions.
• Developed, modified, and optimized complex queries to data retrieval and modification.
• Created Clustered and Non Clustered indexes on tables including the re-build of indexes.
• Responsible for Installing and Configuring of SQL Server 2005 with updates service packs, Performance Tuning and provided 24x7 support for all Production, Development and Clustered Servers.
• Designing database security principles. Manage access to SQL Server Instances, Databases, Schemas, Tables and Programmable Objects.
• Understanding of Application Architecture, Application Design, Transactions Isolation levels, Transact-SQL Code.
• Performing Server-Side Tracing like scripting server-side traces, querying server-side trace metadata, retrieving data, stopping Closing traces.
• Troubleshooting and analysis using commonly used SQL trace event classes, identifying exceptions, debugging deadlocks and stored procedure debugging.
• Implementing Query improvements like rewriting query, schema improvements, statistics management, creating useful indexes and optimization.
• Developed and implemented maintenance procedures.
• Performing administrative tasks like database files management, backup and restore database, security management, data integration and synchronization.
• Worked on Disaster Recovery with High availability systems, log shipping, Back up strategies and scheduling the regular back ups, Replication, Clustering, configuration of RAID levels.
• Worked in the clustered environment of both Active-Active Active-Passive.
• Worked closely with IT project managers, programmers, and testers to ensure the database integrity and security.

Environment: SQL Server 2000,SQL Server 2005, Windows 2003 Server, MS Access, ASP, Java Script, MS Reporting Services, HTML, Cluster.

Confidential

Role: Database Administrator/ Database Developer

Responsibilities:

• Creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures in SQL Server 2000.
• Using Linked Servers and Ad Hoc Connections for inserting, updating and deleting data.
• Importing, Exporting and Copying objects using DTS Import/Export Wizard.
• Using DTS Designer to Build Packages by creating Connection Objects, Tasks and Precedence Constraints.
• Working with DTS Packages by Saving, Securing, Backing Up and Executing Packages.
• Configuration of Parallel Execution of Tasks, Execution Priority and Definition of Package Failure.
• Dynamically Configuring DTS Package Objects.
• Using ActiveX Scripts Tasks. Incorporating Error Handling into DTS Packages.
• Involved in implementation of replications like Snapshot and Transactional.
• Scheduled and created Maintenance plans on Production databases.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Managing security, which includes monitoring and controlling database access, assigning permissions to application owners.
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24/7 running. On call 24/7 support to databases on weekly rotation.
• Data integrity ownership and responsibilities communicated to appropriate business owner's acceptance of responsibilities.

Environment: SQL Server 2000, DTS, ER Diagrams, Windows 2003 Server, .NET.

Confidential

Role: T-SQL Programmer

Responsibilities:

• Designed Logical and Physical database models.
• Created a tables and provide constraints and user defined rules and defaults.
• Created views, indexes, stored procedures, triggers and constraints.
• Developed various functions at database server level.
• Coded SQL to perform database tasks such as inserts, updates and deletes.
• Coded SQL to perform database tasks by using inner/Outer joins and group by/having clause.
• Created Database objects like Stores Procedures, Triggers, Views, and Rules etc.
• Involved in front-end Development and Report Generation.

Environment: SQL Server 2000, ER Diagrams, Windows 2003 Server, .NET.

Confidential

Role: Database Developer / Database Administration

Responsibilities:

• Implementation of relational database concepts such as referential integrity.
• Experience in Data modeling and creating Entity-Relationship Diagrams.
• Modeling the relationships between entities of database using Entity Relationship diagram.
• Create new database objects like tables, views, stored procedures and functions.
• Understanding of Data types and its usage.
• Implementation of constraints in database design.
• Understanding of Data files, Log files and Filegroups.
• Understanding of major differences between editions available with SQL Server 2000.
• Expertise in installation and Management of SQL Server 2000.
• Creating jobs to backup databases.
• Deliver requirements documents like System Features, Use Cases, Business Rules and Process Flow.
• Involved in designing of Web pages using HTML and XML.
• Clear understanding of Active Directory concepts.

Environment: SQL Server 2000, ASP, JavaScript, HTML, VBScript, Java Script, XML, Active Directory, IIS