SUMMARY:

• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security and Data Transformation Services, coding, testing and supporting very large volume and complex SQL server Databases in Production, Staging, test and development on cluster/standalone environments.
• Good knowledge of Relational Database Management Systems (RDBMS) and Software Development Life cycle (SDLC) to ensure security controls are in place.
• Experience in Development for very large and complex databases in SQL Server 2016/2014/2012/2008/2005/2000.
• Experience in Installing, configuring, upgrading and maintaining SQL Server Active/Active and Active/Passive cluster, SSIS, SSRS and related products.
• Experience in installing Service Packs for SQL Server and OS.
• Migrated of SQL Server databases into SQL Server 2005, 2008, 2012, 2014 and 2016 versions and migrated Oracle and Sybase to SQL server using Microsoft SQL migration tool.
• Highly skilled in implementing types of High Availability & disaster recovery scenarios like SQL Server Database clustering, Always on Availability Group, Replication models (Snapshot, transactional), log shipping, Database mirroring and windows cluster.
• Outstanding experience in SQL Enterprises Manager and SSMS - creating and scheduling jobs, alert and operators with SQL Server Agent, SQL Profiler, Backup/Recovery databases.
• Good Knowledge in preparing and updating cost cutting and disaster recovery documentation.
• Developed backup and recovery strategies for production environment.
• Excellent programming skills on T-SQL scripting.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Creating stored procedures, functions, packages, triggers, according to business requirements.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience using a wide variety of security tools and monitoring tools to include Wireshark, UIM, Oracle Audit vault and Oracle EM12c.
• Design and deliver Encryption, TDE, CDC, key management and PKI related solutions.
• Usage of update statistics on both table & index views and indexes
• Implementing automation using server agent & third-party task scheduler tools
• Experience in and Data security operations
• Knowledge in Windows/Linux, UNIX operating system configuration, utilities.
• Flexible, enthusiastic and project-oriented team player with solid leadership skills to develop creative solution for challenging client needs.
• Good knowledge on IBM Infosphere Guardium, Symantec Data Loss Prevention Vontu, Cyber Ark and Vormaitc encryption to enhance the security.
• Worked strongly following Agile (Scrum) methodology.
• Knowledge in Authentication, Endpoint Security, Firewalls, Database Activity Monitoring.
• Hands on experience with Change Management, incident response.
• Experience working with 24x7 Production support.

TECHNICAL SKILLS:

Databases: SQL Server 2005, 2008, 2012, 2014 and 2016, Oracle, MS Access

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig.

Server O/S: Windows NT 4/Windows Server 2000/2003/2008/2012 Advanced Server, UNIX.

High Availability: MS SQL Server Mirroring, Replication, Always On, SQL server clustering

Client O/S: Windows 95, 98, ME, 2000, XP, Vista, Windows 7

Tools: Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, AWSSurface Area Configuration, SQL Server BI Tools (SSRS Query Builder, BIDS, SSIS, SSAS), SCOM, Oracle Enterprise Manager, MS OFFICE 2000/XP/2003/2007, BMC, UIM, Cyber Ark, Vormaitc Perf Mon, Backup Utility, SQL Lite Speed, Visio, ERWIN, RML Utility, Pal, DLP Vontu, IBM Infosphere Guardiam.

Languages: C, C++, SQL, PL/SQL, PowerShell scripting, HTML, Visual Basic 5/6, Java 1.2

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, CA

Sr. MSSQL Database SME Lead.

Responsibilities:

• Working as Database Engineer on a new project which is client facing applications.
• Configured and maintain of several SQL server version and applied Service Packs (SP) and hot fixes on SQL Server 2014 and 2016 Instances.
• Support the Store system application for any tuning and Migrating the version on the ISP’s and store systems
• Working on reviewing and enhancing backup and recovery policies and creating minimum baseline security for SQL server versions to implement on the Database instance before going live.
• Install and configure database server, SSRS and work with the vendor to build the databases.
• Handing multiple 3.5 TB databases with clustered environment.
• Creating standards for Database Installations, Monitoring strategies, Auditing, Storage requirements and Netback up for Cold and Hot backups.
• Perform day to day activities such as check OS event logs and SQL Server logs, failed SQL Server Agent Jobs, disk space, blocking issues and scheduled job running successfully.
• Installed/configured/managed disaster recovery solutions using always on availability, SQL Server Failover Clustering environments for High Availability.
• Created, edited, and updated technical documentation used by the entire team.
• Implemented migration side-by-side and in-place upgrades of MS SQL Server.
• Configuring, deploying projects to SSIS and SSRS servers and provide reports using reporting server.
• Implemented Always On, Database Mirroring, including custom-scripted (with some PowerShell) re-configuration of automatic failover partners and voting and custom-scripted SQL Server Agent job enabling per primary/secondary status of availability groups (AGs), automated TDE & AG for new databases.
• Having knowledge to implement SQL server Polybase, Azure, AWS and Hadoop cluster.
• Experience in providing security permissions and enabling fire walls on SQL Azure databases Migrated SQL Server Database from Local to AWS environment
• Monitored SQL server performance using various tools like UIM and native SQL tools to find database performance issues.
• Monitored and modified performance using execution plans and Index tuning;
• Authored & managed DR exercises.
• Assess the database security vulnerabilities recommended and implement database security solutions.
• Build and maintain SQL scripts and complex queries for data analysis between CORP and Store ISP.
• Provide database coding to support business applications using T-SQL for Data Purge.
• Involved in setup, installation, configuration Hadoop Cluster.
• Responsible for Cluster maintenance, commissioning and decommissioning Data nodes, Cluster and review data backups, Manage & review Hadoop log files.
• Troubleshoot and resolve issues escalated from customer support.
• Ensured the immediate resolution of issues so that all project deliverables were within SLA timeline.
• Developed and managed project plans while providing status updates to management.
• Worked with App teams to address technical issues and develop effective resolutions.
• Rotation based 24 X 7 on call support for Production environments.

Confidential, San Jose, CA

SQL Server Database Administrator & Data Security Engineer

Responsibilities:

• Installed, Configured MSSQL 2012, 2014 and 2016 to setup a DEV and QA environment to validate the scanning tools.
• Migrated data from Sybase to SQL server 2016
• Experience Migration of On Premise databases to SQL Azure environment.
• Installed and maintained the Basic Availability Always on with Standard edition 2016.
• Implement the data scans on the SQL server and Oracle database to find Security Violations along with day to day DBA activity.
• Experience in configuring and run scanning using IBM Infosphere Guardium (tool) to scan structured (Oracle, MS SQL, and Teradata Databases)
• Implemented Data scans against databases, ensuring tool/scan doesn’t impact Business as Usual functions
• Maintained and supported SCOM platform.
• Created design, Policy’s from customer business requirement and created the reports for forensic investigation.
• Implemented Data scans against databases, ensuring tool/scan doesn’t impact Business as Usual functions
• Work with different Business Unit teams to help them understand the vulnerabilities listed and provide the recommendations
• Coordinating with application and other database teams to triage results of scan to identify false-positives versus valid findings.
• Co-ordinate with the offshore team for daily activities (Snow ticket review for daily task issues)
• Participate in the kick off Meetings with Global Security Team and Qualys Support team for ongoing issues and what is expected from the Team.
• Evaluating, computing security risk events and develops Incident response plans.
• Continuous development, testing and evidence collection, processing, basic analysis, remediation processes and providing enterprise-wide security recommendations for client that help mitigate vulnerabilities and prevent future attacks.
• Performs research and investigations for Security Risk Management
• Implement Data scanning on Network Attached Storage.
• Experienced in setting up policies for the Filer scanning using DLP Vontu tool
• Worked on creating automation scans on CORP Network Attached Storage Filers using DLP vontu.
• Created JIRA and Change request for the remediation process of the found violations
• Implemented TDE, CDC on the databases.
• Created detailed Documents for the Data scanning activity.

Confidential, Culver City, CA

SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2014/2012/2008 production and Non-production servers.
• Installation of SQL Server 2008 on Windows Server Clustered environment.
• Upgraded/Migrated SQL Server 2008/2005 databases to SQL Server 2014/2012 databases.
• Installed, Configured and implemented Database Mirroring, replication, Always on Fail-Over Cluster Servers in SQL Server 2012
• Performed backup using backup compression and Data compression in SQL Server 2014, 2012, 2008 on clustered environment.
• Handled up to 2.5 TB Size databases with clustered environment.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Extensively worked on Profiler, Perfmon, and DMVs, to tune the databases, servers and query tuning.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
• Analyze execution plans and generate suggestions for improvement.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities.
• Worked with Cyber Ark for implementing of privileged and control account access to authorized user on the Database servers.
• Participate in security Assessments of networks, systems and applications
• Work on improvements for provided security services, including the continuous enhancement of existing methodology material and supporting assets.
• Performed functional testing of security solutions like RSA two factor authentication, Novel single sign on, DLP.
• Work on the root cause Analysis after the Security scans and perform the fix or address the team to follow the steps and fix the issues
• Worked on various business development activities like drafting response to RFP's and preparing SOW's documents
• Hands on experience working with AWS to access the database serves etc.
• Implemented Vormaitc encryption on the server level and preformed testing.
• Worked with Delphix for creating DEV Oracle databases.

Confidential, Sacramento, CA

SQL Server DBA

Responsibilities:

• Environment: MS SQL Server 2005/2008/2008 R2 Developer, Standard and Enterprise edition,
• Managed Migration of MS SQL Servers 2008R2 to 2012 and Performed upgrades and service packs.
• Involved in the design and implementation of Disaster Recovery or data recovery plan (DRP), involving database servers and application servers.
• Installation of SQL Server 2012 with latest Service Packs.
• Monitored, troubleshoot, Optimized and fine-tuned databases' Performance issues using Database Tuning advisor, SQL server Profiler, Monitors, DBCC and DMVs.
• Developed and performed SQL server post installation Maintenance plans: Database backups, Integrity Checks, Update Database Statistics and Index maintenance using GUI and T-SQL.
• Managed SQL Server Security including Implementation of SQL Logins, Roles, Authentication Modes and SQL server Audits for various users.
• Involved in Design and implementing SQL server comprehensive disaster recovery strategies including log shipping, replication and mirroring.
• Participated in primary and secondary on call rotation and provided on-call troubleshooting for SQL Server service outages after hours.
• Performed security assessment, review, and mitigation of the SQL, Oracle databases and Windows server operating systems
• Worked on Root cause Analysis perform the fix or address the team to follow the steps and fix the issues.
• Provided the data security by using encryption in SQL Server 2012/2008 like for protecting passwords used encryption.
• Worked on ORACLE Enterprise Manager Cloud Control version 12C.
• Monitoring Groups, Templates, Incident rules, Notification.
• Assisting customer in understanding risk and threat level associated with vulnerability so that customer may or may not accept risk with respect to business criticality
• Conducted security assessment of PKI Enabled Applications.
• Worked on Oracle Audit Vault and Database Firewall Version 12.1.1.1.0
• Supported 24 X 7 Production environments.

Confidential

SQL Server DBA

Responsibilities:

• Installation of SQL Server 2008 with latest Service Packs.
• Migration of SQL Server 2000 to SQL Server 2005/2008 using side by side strategy.
• Designed new databases architecture according to Business requirements like logical design and physical design.
• Handled Clustering between 3 Production Servers and performed daily backups and developed Recovery procedures.
• Implemented Log Shipping in SQL 2008/2005.
• Implemented Transactional and Snapshot Replication in SQL 2008.
• Implemented Disaster Recovery Strategies.
• Involved in creation of database snapshot.
• Created partition tables using partition functions and partition scheme.
• Providing 24x7 supports to SQL application developers in implementing the applications on Production server.
• Migrated stored procedures from SQL 2000 to SQL 2005.
• Resolved locking and blocking issues.
• Created stored procedures, scripts, cursors for the Bulk application, tested them on the test servers and moved them to production.
• Daily monitoring of the database performance and network issues.
• Performance tuning and optimization of procedures and queries.
• Rebuilding indexes (online and offline) on various tables.
• Connecting SQL servers remotely using Terminal services.
• Worked with SQL Server Profiler to generate traces.
• Monitored databases and alerts from Fog-light application.
• Creating backup strategies and scheduling them for execution.
• Created crystal reports and scheduled them as daily and monthly reports.
• Creating logins, users and assigning them permissions on demand.
• Helped Development Team in deploying and testing the application.
• Upgrading DTS Packages to SQL Server Integration Services (SSIS).
• Scheduled SSIS Jobs and Maintenance Plans.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Create Packages and jobs to perform filtering operations and import the data on daily basis from the Oracle DB to SQL server.
• Created and Migrated DTS packages from SQL Server 2000/2005 to SQL Server 2005/2008 Integration Services (SSIS).
• Developed and Tested SSIS (SQL Server Integration Services) Packages for data extraction, transfer, and loading for different applications.
• Involved in moving SSIS packages between various environments including Development, Test, System Test, UAT (User Acceptance Testing) and Production.
• Set up jobs to schedule SSIS packages using SQL Agent.

Confidential, Irving, TX

SQL Server DBA/ Developer

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
• Interacted with Developers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Managing Production SQL Servers on VIRTUAL and PHYSICAL environments
• Configured Active/Active and Active/passive SQL Server Clusters.
• Implemented Mirroring and Log Shipping for Disaster recovery
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduled jobs on production and staging environment.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries.