SUMMARY:

• Responsible for ensuring the database technical and functional designs meet business requirements. A hands - on Experience with Migrated database from SQL 2005 Database to SQL 2008, SQL 2012, 2014 and 2016 as well as performed administrative tasks like database files management, backup/restore, security management, data integration
• Solid skills with using DataStage, Oracle, and Teradata.
• Microsoft SQL Server 2008/2014 Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and SQL 2012 Always ON.
• 8+ years of DBA experience in SQL Server
• Installed and configured SQL Server 2005, SQL server 2008, SQL server 2008R2, SQL Server 2012, 2014 and 2016 on Windows Server 2003, Windows Server 2008 and Microsoft SQL Server 2016 and Windows Server operating systems
• Windows Server 2008R2, applied service packs and security fixes.
• Configure and Maintain Always On HA on SQL Server 2008R2
• Responsible for a large scale of database migration from SQL server 2005 to SQL server 2008, SQL server 2008R2 and SQL Server 2012,2014 and 2016
• Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Moved data from flat file, Excel, Oracle, MS Access, OLEDB Data Sources to SQL Server
• Providing 24x7 dedicated On-Call productions supports for SQL Server problem resolution and server outages.
• Involve in creating Logical & Physical Database Design.
• Responsible for configuring and maintaining transactional replication in different environments.
• Responsible for configuring and maintaining Database Mirroring & Log Shipping
• Using Lite Speed ensuring all the databases are backed up on the regular basis and restoring databases as requested.
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Improving database performance using SQL Profiler, Trace Flags, Execution plan and DTA.
• Working with installation, configuration and creation of SSRS
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0
• Deployed Reports and managed security of report server including folder level
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• SSIS Package create, deploy and manage
• Strong experience on user management, assigning permissions & roles
• Working with SSIS and DTS package to import & export operations in and out of the SQL Servers. Working with Central Management Server
• Development and debugging experience SSIS, SSAS, and SSRS
• Strong knowledge of SQL Server administration.
• Experience working in large, complex environment with more than 15 production servers
• Facilitate SSRS and SSIS package deployments.

SKILL:

RDBMS: SQL Server 2005/2008/2012/2014 ); Data Modeling; High Availability (Log Shipping, ReplicationMirroring, SQL Clustering, Always On availability); Performance Monitoring Tools (Profiler, DMV, Activity Monitor, PerfMon, Extended Event, DB Tuning advisor); backup and restore, backup and restore recovery model, ETL Tools SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS) DTS; Cloud Computing/Azure;

Database: Dictionary (5 + years)

• Database (RDBMS): SQL Server …

• Data Modeling: SSDD (SQL Server Database Diagram), Toad Data Modeler, Erwin

• High availability: Log shipping, Replications, Mirroring, SQL clustering, Always on availability• Performance Monitoring Tool Profiler, DMV, Activity Monitor, Execution Plan, PerfMon, Extended EventDatabase Tuning Advisor

• Reports Development/Management: SSRS, MS Access, Excel

• SQL Database Tools: SQL Profiler, SQL Agents, SQL Alerts, SQL Jobs, Database Mail, Query Analyzer Query Execution Plan, Counter

• ETL Tools: DTS, SSIS

• Operating System: Microsoft Windows Server … 2008 … Windows XP/vista/Win7&8, 10, Cloud Computing/

PROFESSIONAL EXPERIENCE:

SQL Database Analyst/Modeler

Confidential

Responsibilities:

• Responsible for the design, implementation, configuration, maintenance, and performance of critical SQL Server systems, ensure the availability and consistent performance of clients 24/7 enterprise applications. Designed and implemented Teradata physical, access, and semantic database layers for use in new Teradata Data Warehouse. Additional responsibilities include establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system. Created Oracle tables and indexes to support the ETL effort. Solid technical skills, as well as excellent interpersonal and communication skills.
• Migrating database using different tools (copy database wizard, detach & attach, SSIS, etc) and data conversion and managing orphaned users
• Installed new SQL Servers, upgraded and configured MS SQL Server R2 and 2012
• Implement Disaster Recovery and High Availability plans such as Log-Shipping, Database Mirroring, Replication, SQL server clustering and Always-On
• Checked databases/servers are healthy and functioning as expected; look at unusual error log messages and do root cause analysis.
• Security enforcement and proper documentation of changes
• Created Database Maintenance Plan for database Integrity Checks, Updated Database Statistics and index rebuild as well as index reorganize
• Loaded data into Teradata and Oracle Data Warehouse using DataStage 8.7 to replace SSIS packages, PL/SQL packages and SQL Loader processes.
• Writing new T-SQL queries.Tuning existing T-SQL queries to improve performance.
• Performed performance testing on stored procedures, indexes, and triggers.
• Developed Reports for different purposes using SSRS and Report Builder
• Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User Defined Data Types and Functions
• Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules
• Developed Database Backup Scripts and automated this process/tasks using SQL Server Agent Service
• Transferring Jobs and Logins using SSIS from SQL server .
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
• Configured transactional replication between OLTP server and report server.
• Performed various disaster scenarios and also documented the recovery steps.
• Used Windows Performance monitor and SQL Profiler to optimize queries, resolve deadlock issues and enhance the performance of database servers
• Extensively documented all the databases, database objects, jobs and the changes made to the database
• Used extended Stored Procedures for creating alerts for critical production jobs
• Worked as part of a team and provided 7×24 support when required

Work Environment: Windows server 2008R2 Enterprise edition, MS SQL Server 2008/R2, 2005 Enterprise edition, SSRS, SSIS, T-SQL, ETL, Visual studio, MS Access, Excel, SQL Profiler, Windows

Confidential, UPPER MALBORRO, MD

DBA

Responsibilities:

• SQL server Installation and maintaining SQL servers 2014, 2012, 2008R2, 2005.
• Applying patches on both production and non-production servers.
• Database creation, database refreshes, alert monitoring and Backup script creations.
• Database migration from SQL 2008 R2 to SQL Server 2012 and 2014.
• Supporting multiple customers and providing as per business solutions.
• Having good experience on implementing and managing Always on feature on SQL server 2012.
• Worked with Unicode and Latin character sets within DataStage, Oracle, and Teradata to support multiple languages and alphabets.
• Have configured log shipping and as per customer requirements.
• Checking the database data files and log files is located specific drive and observe the available free space.
• Addressed the Replication Issues and have settled up the new replications.
• Patching all the DB Servers to the Latest Service Pack levels periodically to be Compliant with the Microsoft Support.
• Database refreshes from production backup to non-production servers.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Experience in using DMV and dynamic management functions to find out long running queries.
• Experience in setting up two node Active-Active and Active-Passive clustering.
• Created the SQL Server Integration Services (SSIS) Packages for exporting the data.
• Implemented SQL Server new feat users like Policy Based management, Performance Data Collector and Transparent Data Encryption (TDE),
• Configuring database mail for SQL server alerts.
• Checking Alerts and resolve issues to take appropriate action as need.
• Configuration and troubleshooting issue in Database mirroring.
• Managing user creation and providing permission as per user's requirements.
• Set up linked servers and troubleshooting any issues related to ODBC connectivity.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks
• Responsible for trouble shooting failed jobs and Replication Related issues etc.
• Monitoring the Scheduled jobs and fixing the failed jobs.
• Checking Fragmentation and Resolving Fragmentation issues.
• Rebuilding the indexes at regular intervals for better performance.
• Participate in meetings and partner calls regarding support issues and processes on weekly basis
• As a part of the DBA team providing 24x7 production support to the clients.

SQL server Database Administrator

Confidential

Responsibilities:

• Installed, upgraded, configured and administered Four-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment. Installed and configured SQL server 2012, and migrated data from SQL server 2012.
• On routine basis was responsible for providing 24 X 7 critical production supports to numerous production, development and clustered servers.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Developed Enterprise Data Warehouse using STAR schema, Oracle DB and Oracle tools.
• Experienced working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• Rebuilding /reorganize and monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters, implementing Point-In-Time Recovery solutions.
• Extensively used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Used the DBCC commands for maintaining database, indexing, and validation operations, enabling trace flags or removing DLL from memory.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Used signed modules extensively for encrypted stored procedures, functions, triggers and assemblies.
• Very well versed working with different types of backups like Full, Differential and Transactional log backups.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Monitoring of database size and disk space in Production, Staging & Development environments.
• Day-to-Day administration of SQL Servers on Standalone and Cluster Environments.
• Created and maintained various logins and managed security of the database based on the required access
• Responsible for monitoring and making recommendations for performance improvement, troubleshooting, planning and migration in hosted databases. This involved index creation, index removal, index reorganizing, index rebuilding, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio, and troubleshooting with connectivity, security and firewall issues.
• Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports; Developed Database Dictionary.
• Expert in implementing the snapshot isolation and DDL triggers.
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training
• Expert in using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

SQL Server /DBA

Confidential

Responsibilities:

• Involved in Planning, Defining and Designing database using conceptual, logical and physical models based on business requirements and provided documentation.
• Provide database administration and support on production and development SQL server 2005 and 2008
• Login and User Management: Adding logins, roles, groups to the MS SQL Server and managed security on Production and Development environments
• Migrated data using Import/Export, bulk and batch processing, backup-restore, DTS, SSIS, Import/Export.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored performance of SQL Server 2005 and SQL server 2008 databases
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Perform daily system check and maintenance job, create alerts.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Backup and Restore of mission critical databases and system databases and validated the same.
• Hands-on experience in using FILLFACTOR and Updating statistics
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Wrote stored procedures, checking the code for efficiency.
• Expert in implementing the snapshot isolations and DDL triggers.
• Supported IT Operations by performing database related and analysis tasks, report writing and handling multiple database projects.
• Write and execute Upgrade scripts for making change to the production server
• Extensively worked on Dynamic Management Views in SQL Server 2008/2012.
• Experienced in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Create scripts and various database objects per customer request
• Employed DAC (Dedicated Admin Connection) when the normal connection fails to connect.
• Maintaining the database consistency with DBCC at regular intervals
• Create and manage database objects, stored procedures, triggers, views and functions
• Perform system design, development, maintenance and deployment
• Scheduling Jobs and Alerting using SQL Server Agent
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports using SSRS

Confidential

SQL Server /DBA

Responsibilities:

• Involved in complete database design including conceptual, logical and physical models
• Installed, Configured, and Managed SQL Server 2005, 2008 engine and reporting service.
• Configured and maintained the Transactional replication in the production environments.
• Scheduled database maintenance tasks to improve the database performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Upgraded database using in place and side by side method.
• Responsible for Database Backup, Restore and Point-in-Time Recovery.
• Data modeling using Toad Data Modeler and Visio.
• Rebuilding/reorganizing the indexes at regular intervals for better performance.
• Involved in maintaining database with maximum database availability, resolve any database issues.
• Migrated and tested DTS packages, Export & Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS
• Tuned and configured the production and development database servers.
• Created the stored procedures, views and scripts
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Experience with DBCC commands, to check physical and logical consistency of the databases.
• Apply service pack and hot fixes and solving the Bugs Reflected by the Testing team
• Expertise in database Performance tuning.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Managed Database security
• Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/ Check), Views, Stored Procedures, Triggers
• Configure and maintain Database mirroring, Log shipping.