Professional in Administering and SQL
Server 2008/2008R2/2012/2014 and 2016 with 8+ years of experience as a Microsoft SQL Server Database Administrator,
Developer and manager in production and
non-production environment. Experience in core DBA tasks like installation,
migration and configuration including designing and implementing disaster recovery procedures, excellent
problem solving ability, a good team player and ability to learn new emerging
SQL Server Migration
Maintenance and troubleshooting
SSIS packages (ETL)
Always On Clustering
Amazon Web Services(AWS)
SCOMMirroring and Log shipping
Database Encryption TDE Encryption
SQL Server DBA/Production Support DBA July 2017 to CurrentLiberity Mutual Insurance － Colombia, MD
configured, administered SQL Server 2008R2/2012/2014 and 2016 on production and
Pro-actively and regularly monitoring of CPU, Disk I/O, memory related
bottlenecks, deadlock and carried out similar other tasks.
Performed various Troubleshooting methodologies to identify and resolve system and
user related issues.
and configured windows server 2014 and 2016 failover clustering Active/Passive and configured Always-ON for High availability and disaster recovery (DR) solutions.
Created Jobs, Alerts and Notifications
for system errors, insufficient resources, fatal database errors, hardware
errors, security breach-technical guidance, task assignment and tracking.
Managed database Maintenance tasks such as index fragmentation, DBCC
operations, monitoring performance and optimizing queries for
implemented and deployed multitude applications utilizing AWS
Route53, S3, RDS, Dynamo DB, SQS, IAM, Elastic Load balancer (ELB) and VPC)
Installed, maintained & monitored production SQL servers and making sure
they are up-to-date with latest rollup
Patch and service packs. Designed
and Implemented log shipping, mirroring,
replication from primary site to the secondary site to support mission
critical applications and offload queries.
Wrote Complex T-SQL Script for Store procedure, joins.
multiple databases/SSIS packages/SSRS
reports/SSAS cubes between different SQL versions 2008R2/2012/2014 and 2016
in both in In-place and Side-by-Side migration methods.
data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
business analysis and write effective
documentation and specifications
Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text
Format Data) by using multiple transformations provided by SSIS such as Data
Conversion, Conditional Split, Bulk Insert, merge and union all.
complex reports using Cascading
parameters, Drill-Through Reports, Parameterized Reports and Report Models
and Ad-hoc reports using SQL Server Reporting Services (SSRS) based on client
database backup, restore and other maintenance plans for user and system
on T SQL with store procedure, triggers, functions and views for the
implementation of DDL and DML.
on Native and third party performance monitoring tools like SCOM, SQL Secure Idera
Migrated the current Windows
environment to AWS/RAHEL environment
and worked on Script language using with AWS Command Line Interface (CLI).
& Managing the Table spaces and data files growth, Analysing
Tables & Schemas, collecting system
statistics and rebuilding indexes. Worked
on several existing production users, databases,
jobs, packages, reports, linked server, logins and other computer objects to
new versions of SQL server.
automated daily, weekly and monthly SQL server agent jobs such as a database
backup, integrity checks, and indexing maintenance and update statistics
Worked on performance tuning, optimization
of stored procedures and queries.
database refresh from production to test using custom scripts Created
databases, Logins, Roles and granted appropriate permissions.
· Identified and resolved security threats such as SQL injection, user name and password
masking by applying SQL Credential
and Proxy accounts.
on Soft Ware development life cycle (SDLC) in agile environments. Handling
day to day support tickets and development and production issues.
24 X 7 Production on Call Support.
SQL Database Administrator (DBA)/Developer March 2014 to June 2016 Freddie Mac March' 2014 － McLean, Virginia
Install, configure and administer MS
SQL server 2012 and 2014. Monitored
and troubleshoot server performance, database activities and clients'
Configure and administer Availability Groups for high availability/Always On of multiple databases.
complex stored procedures, Help developers to optimize queries, triggers, database design and UDFs to support efficient data
storage and manipulation.
Successfully Installed configured,
Managed and administer a traditional SQL Server failover Cluster with 2 nodes.
Worked on Relational database
management tools on FICO for debt management system in finance.
Created and administered various jobs
to handle different tasks and to monitor resources on various servers and to
email the necessary information when threshold was reached.
Apply SQL Server patches; Service
Packs, Hot-fixes, and Cumulative Updates as required and created
documentation for tracking. Implement Database optimization such as performance
tuning and improvement using Dynamic management views and functions and
others. Design, Develop and implement SQL
server reporting service that extracts data and present in the user friendly
Intensively analyzed the existing
system in regard to the database management and produced an inception report
which describes the existing situation, pros and cons, and future intervention
and plan of action (short, midterm and long-term).
SQL server Always on high availability and disaster recovery
solutions including mirroring, replication
and log shipping.
Created linked servers to perform distributed
queries and data transfer. Establish a modality to collect the
information and documentation of the existing system.
Develop procedures/protocols on
database planning and implementation, database security aspects, database
auditing, backup and restore modality.
Review the current procedure of backup and restoration, and introduced the
differential back up into the system and periodic restoration of backups.
Applied SQL Server best practices
Including Software development lifecycle.
Provide support for critical databases
that are on Azure and Hyper-V.
Worked with database developer's team
for database design, data modeling and normalization.
Assisted developers in the process of Extract, Transform, and Load (ETL) in data
Created SSIS Packages for Data Flow,
Object Migration and Database Maintenance.
commands to check the database
consistency and shrink the databases.
Participated in enhancing end users'
understanding of database systems by conducting pre-implementation
trainings/workshops and different events.
Manage Very Large databases (VLDBs) of
1TB and more using Table Partitioning, Backup and data Compression and Multiple
file-groups. Responsible for Designing and
implementing the backup strategy
required as per the requirement on production and development environments. Overall follow-up of the system and
user support to address any issues and plan for potential problems in advance.
Database Administrator (DBA) September 2009 to February 2014Unisys Corporation － Reston, , Virginia Sep' 2009
– Feb' 2014
Environment: SQL Server 2008R2/2012/2014,2016, DB2,Oracle Windows server 2008/2012R2, AWS, Backup Utility(net backup), Quest
spotlight, SQL Lite speed, SSIS,
SSRS,SSAS PCI, DSS, C#, TDE, Java
Script, Idera technologies Like SQL
secure, AWS, .Net ,FICO VMware,
SharePoint, Master Data Services (MDS),Extended Events.