We provide IT Staff Augmentation Services!

Sr. Mssql Database Sme Lead. Resume

Dublin, CA

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.

Hire Now