SUMMARY:

• Multi - talented Profession 8+ Years are managing multiple MS SQL Servers with very large OLTP DBs.
• Four Years of Windows Server, Network Deployment, and Data center hardware technical support.
• Experience in Production / Development / Testing / Microsoft SQL Server / Azure / AWS.
• Data Administration / Documentation / Change management procedure / TSQL / PowerShell / VMware.
• RTO / RPO / Always on / Clustering / Replication / Log shipping / Backup and Restore / Point in time.
• Expert in Upgrade / Data Migration / ETL / SSIS / SSRS / Data Warehousing / TFS / Jira / Agile / Waterfall.
• Experience on MOM / SCOM / IBM Tivoli storage manager (TSM) / TDP / Backup and restore.
• Configuration Management / Native Tools / Ola Hallegren / DPA Solar Winds / Idera / Red gate.
• Data Security / Auditing / Data Encryption TDE / Masking / Policy Management / Firewall / VLAN / DMZ.
• Performance and Query Optimization / Pro-active Maintenance / Change Data Capture / Automation.
• Logical and Physical DB Design / Constraint / Normalization / SP / Trigger / Function / views / CTE
• Windows Server R2 / ADDS / Active Directory / DNS / Users and Computers / GPO / Security.
• Data Center / SAS / SAN / RAID / Network Development / Network Security / Firewall, Router and Layer 3 Switch Configuration / Subnet / IP Address / Hardware Support / MS Office / Office 365.
• Incredible technical and problem-solving skill / Ability to prioritize work and deliver to deadlines / apply best practices and company rule to the SQL Server / Excellent communication skills and team player / Motivated to learn new technologies and methodologies.

PROFESSIONAL EXPERIENCE:

Confidential, MD

SQL DBA /SQL DEVELOPER

• Working as senior SQL Server DBA responsible for enterprise operations for Microsoft database technologies providing 24x7 on-call production supports including after-hours and weekends.
• Responsible for Designing, implementation, administration, and support of over 120 Servers, SQL Server instances, which are hosting over 400 databases.
• Production DBA responsible for optimization, indexing, and database OLTP/OLAP design, including file group and partitioned data for VLDBs of over 20 TB.
• Performing scheduled maintenance and support release deployment activities after hours.
• Involve in all phases of Software development life cycle (SDLC) including requirement gathering, analysis, design, development, testing, production, and post-production support.
• Present, recommend, and implement the best way of database administration technologies.
• Working on a day to day tasks:-checking error logs failed SQL jobs, failed backup, availability of the service, request handling, storage status, database integrity, scale up, and scale out capacity planning.
• Proficiency Skill on Side by side migration from SQL Server 2008R2 to 2014/2016 using different tools.
• Responsible for performance issues arise, determine the most effective way to increase performance, including hardware purchases, server configuration changes, or index/query changes.
• Responsible for documentation of processes and reliable SQL Server infrastructure by properly implementing best practices, automation, and keeping up with the latest trends in the database.
• Expert in designing, implementing, and administering (HADR):- always on availability group, failover clustering, database mirroring, replication (One way/Two way), plan backup and restore strategy.
• Involve in implementations of always-on AG replicas, listeners, synchronization, and backup options.
• An expert on implementing Database Backup, Restore and Point-in-Time Recovery, including VLDB.
• Hands-on experience in implementing advanced security techniques Data security like Transparent Data Encryption (TDE), auditing activities, policy management, contained database, and permission.
• Experience in creating users, allow, deny, and revoke user/group at the minimum level of permission.
• Hands of experience using IDERA, Solar Wind, Profiler, activity monitor, perf-mo, DMV\DMF, DBCC commands, DTA to analyze and fine-tuning of long-running queries, stored procedures, and wait stats.
• Responsible for performance tuning by analyzing physical I\O reading, actual and estimated execution plans, including updating statistics, query optimization, re-Indexing, and re-organized.
• Hands-on experience in deployment and administration of SSRS reports using SSDT 2016 Report Server.
• Experience in an extract, transform and load (ETL) data from various heterogeneous sources like Oracle, MS Access, flat file, CSV file, Excel, and DB2 using SSDT 2017 and load into a warehouse.
• Proficiency in design, creating Database normalization, data integrity, constraint, DB, tables, indexes, stored procedures, functions, views, triggers, and CTE to implement business logic and data protection.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Participate in complete database design, including conceptual, logical, and physical models using Erwin.
• SQL Server installations, patches, upgrades, including both standalone, clustered environments and VM of production, test, and development.

Confidential, VA

SQL Server DBA/ETL Developer

• Administration of different versions of SQL Server production, development and test environment using Idera Database management tool.
• Responsible on a routine basis providing 24X7 critical production support to numerous productions, development, and clustered servers environment.
• Perform database refresh from higher to lower environments.
• Worked on Setting up and manage log shipping, Mirroring, Failover clustering, and Transactional replication in multiple environments as part of a disaster recovery plan and load balancing strategy.
• Worked on table partitions to data archives, reduce resource contention, and improve the performance.
• Skill in proactively monitoring the production Server and optimize stored procedures for better performance, resolve locking conflicts, resource utilization, and enforce policies and standard.
• Used the DBCC commands for maintaining and consistency of the database, indexing, and validation operations, enabling trace flags or removing DLL from memory.
• Scheduling and automating maintenance plans using SQL Server job agent including executing SSIS Package, index rebuild and index reorganize, update statistics, backup, alerts, and notify operators.
• Experience in generates various automated reports based on the statistical analysis of the data from the various time frame and division using SQL Server Reporting Services (SSRS).
• Development and maintenance of SQL Server Reporting Services and SQL Server Integration Services.
• Working experience in creating a tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards, and scorecards report (SSRS) according to business requirement.
• Transformations like Import Column, execute SQL task, Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, Conditional Split, Union all, Script component in SSIS as per the client's Requirement.
• Hands of experience in create SSIS packages for SQL 2008R2/2012 data migrations and loads by provided an estimation of the migration plan regarding feasibility, time duration, and resources.
• Experience in an extract, transform and load (ETL) data from various sources like Oracle, MS Access, flat file, CSV file, Excel, and DB2 using SSDT 2008 and load into a warehouse.
• Worked on database design and development in SQL Server system in OLTP and OLAP environment.
• Experience on deploy Star and Snowflakes Schema and populate the data to DIM and Fact tables.
• Create and optimize database objects, e.g., Tables, Views, indexes, cursors, stored procedures, database management policies, and constraints default Rules, functions, and triggers.
• Responsible for installation, configuration, Patching and upgrade different SQL Server versions in Development, Test, and Production Environment.

Confidential, Washington, DC

SQL Server DBA

• Responsible on database administration on production Servers with Server configuration, performance tuning, and maintenance with outstanding troubleshooting capabilities.
• Responsible for troubleshooting, recovery, tuning of the database, software installation and upgrades, resolving errors and failures, auditing activities, and resource utilization.
• Extensive experience in performing administrative tasks: database files management, backup/restore, security management, database mirroring, and log shipping.
• Effectively resolved the low disk space issues for the production, development, and test Servers by resizing the log and distributing the file group of the data files to a different storage device.
• Exquisite skills in perform query optimize tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), and update statistics.
• Worked on auditing, user’s transaction, login and database action, and any change group.
• Extensively solve issues on locks, blocks, deadlocks, resource utilization, and handling isolation level.
• Worked in proactively monitor database system status to determine early warning signs of issues.
• Create a user/group and allow permission at the minimum level of privilege on the database object.
• Used the DBCC commands for consistency of the database, and validation operations, collecting system information, and perform database maintenance.
• I have worked on performance tuning by analyzing actual and estimated execution plans, including updating statistics, re-Indexing, query optimization.
• Experienced working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• In-depth understanding of user management and database security at different levels to ensure database integrity and secure databases from unauthorized intrusions and data corruption.
• Employed DAC (Dedicated Admin Connection) when the normal connection fails to connect
• Auditing of the database for users transaction, login and database action, and removing orphan users.
• Develop TSQL scripts to create database objects and perform DML and DDL tasks.
• Create Tables, Views, stored procedures, functions, and assist developers with complex query tuning.
• Install, configure SQL Server 2008/2008R2/2012R2 and apply periodic service packs and hot-fixes (cumulative updates) for Dev, Tasting and Prod environments.

Confidential

Junior DBA and System Administrator

• Multitalented Worked in the administration of SQL Server, Windows Server, and Network infrastructure.
• Expertise in automating maintenance jobs in SQL server job agent and task scheduler: such as index rebuilding/reorganizing according to Microsoft recommendation, updating statistics, shrinking database, maintenance cleaning up, full, differential and transactional log backups, and other SSIS package tasks.
• Expert on analyzing and resolve Locks, Blocks, Dead Locks, resource utilization, and Concurrency issues.
• Extensively used SQL profiler, database engine tuning advisor for tuning queries using variables for characteristics and query costs, used numerous customized templates for getting the traces.
• Used SQL native tools like index reorganize and rebuild, DTA, SQL profiler, perf-mon, event viewer. DMV/DMF for performance tuning/analysis, monitoring, and troubleshooting.
• Experience in performing basic administrator tasks on windows servers 2008R2/2003 like scheduling jobs via task scheduler, creating application-specific user groups and users.
• Responsible for Manage users and groups (roles) from Active directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
• Skill on Windows Server ADDS, Active Directory, DNS, GPO, DHCP, and Network Administration.
• Configuring VLANs/Routing/NAT with the firewalls as per the network design and Implementation of Access Lists for allowing/blocking desired traffic.
• Installation and configuration of Physical cabling, IP addressing, configuring, and supporting TCP/IP.
• I have worked on configuring and implementing LAN, VLAN, VTP, STP, RIP v1/v2, EIGRP, OSPF HSRP, GLBP, VRRP, ICMP, PPP, HDLC, PAP, CHAP, and SNMP and 802.x authentication in access layer switch.