Security Data

Location:

Posted:

February 09, 2021

Resume:

SQL SERVER DBA

**+ years solid working experience in SQL Server database administration and development performed with DBA duties all in enterprise environment

Extensive working experience in various industries including oil, banking, financial, including designing, implementing, maintaining, and documenting complex database applications, and data warehouse in a financial environment

Extensive experience with data modeling, logical and physical database design using Erwin

Hands on working experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity

Hands on working experience in stored procedures

Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication, log shipping, SQL Server clustering, mirroring and Always On

Proficient in SQL programming, physical database design, and SQL Performance tuning

Extensive experience in design techniques, ETL processes, relational database theory, N-Tier development

Excellent report creation skills using Microsoft SQL Server Reporting Services

Solid experience in design and construction of data marts and data views using SQL server analysis services

Extensive experience with Administration /Migration of SQL servers on AWS clouding

Industry working experience in SQL Server and Oracle database management, maintenance, performance tuning, and troubleshooting

Extensive experience in providing Enterprise Tier-N Platform Services operational technical support

Solid experience in UML, data-flow and SSIS package design and construction

Extensive experience in administration of DB security, sever auditing and DB risk management.

Proficient in creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams

Excellent communication skills, strong organizational skills and excellent interpersonal skills

AREAS OF EXPERTISE

Category

Technology

Database

SQL server 2019/ SQL server 2017 /SQL server 2016/SQL server 2014/SQL server 2012/SQL Server 2008 R2/2008 Enterprise SQL Server DTS, SSIS, SSRS, SSAS

T-SQL, SQL, PL/SQL, SQL, SQL PLUS

Performance Tuning

Capacity Planning

Installation, Upgrade, & Migration

ODBC, JDBC, OLE DB

OS/Clouding

Windows Enterprise 2012/Windows 2008 R2/Amazon AWS

Applications

Erwin 3.5/4.1

Crystal Report 8.5/9/10, Crystal Enterprise 10

Visual Studio .NET 2013

Language

C/C++, Java, .NET, C#, COM+, Visual C++, HTML, XML, ASP, JSP, JavaScript

Protocols

HTTP, TCP/IP, FTP

WORKING EXPERIENCE

Halcon Resouces 05/2014 – 12/2019

Senior SQL Server DBA

Halcón Resources Corporation (Halcón) is an independent energy company focused on the acquisition, production, exploration and development of onshore liquids-rich assets in the United States.My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of databases, development, and test environment, including hardware configuration, SQL server installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration.

Installed and configured new SQL servers according applications’ requirements including SSRS or SSAS

Upgraded /Migrated SQL servers from old version to newer versions

Monitored and tuned databases to meet the performance and availability requirements.

Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements

Provided support to business operational models, including off-hour support

Generated database SQL scripts and deployed databases including installation and configuration

Ensured the databases updated accurately and regularly

Managed indexes and locks and troubleshoot deadlocks

Developed and implemented maintenance procedures

Planned and co-coordinated database security measures

Communicated regularly with internal technical staff to ensure the database integrity and security

Created and updated database document

Supported development effort by providing T-SQL statement tuning and optimize data loading processes

Maintained day to day operating procedures for SQL Server databases

Provided back-end support for functional testing and performance testing

Managed the production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity

Scheduled and monitored all maintenance activities of SQL Servers including database consistency check, and index defragments

Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities

Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach

Configured securities and access to product databases in on Windows Server

Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers

Implemented and maintained high availability solutions for production servers using Replication, Alwayson high availability group and mirroring.

Power BI server installation, configuration and administration

Created SQL server installation package using PowerShell scripts

Worked closely with application team implementing changes on web application and database structure.

Provided solutions to stabilize and standardize the database system in all environments

Migration SQL Servers to AWS clouding

Environment: SQL server 2019/2017/2016/2014/ 2012, SQL server 2008 R2, Windows Enterprise Server

2012/2008 R2, Amazon AWS, Power BI

Ascende, Houston, TX 12/2012 –04/2014

SQL Server DBA

Ascende is a Houston-based human capital and employee benefits consulting firm in the truest sense. My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of databases, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse. Furthermore, responsible to design and implement databases including tables, relationship, stored procedures, views, user-defined functions, triggers, complex queries, and the indexes for mission-critical business applications. Also responsible to monitor and tune large databases for performance and availability, modify database structures, develop database backup/recovery procedures, and provide support and guidance to operational models.

SQL server 2008 R2/SQL server 2012 became main version in company, all our main jobs are around these versions include installation and maintains

Installed and configured new SQL servers according applications’ requirements including SSRS or SSAS

Designed a lot of complicated reports according business requirements.

Developed, modified, and optimized very complex queries to data retrieval and modification

Generated test data and tested database to meet the functionalities deliverables

Managed indexes and locks and troubleshoot deadlocks

Communicated regularly with internal technical staff to ensure the database integrity and security

Supported development effort by providing T-SQL statement tuning and optimize data loading processes

Maintained day to day operating procedures for SQL Server databases

Provided back-end support for functional testing and performance testing

Developed scripts to migrate data from multiple sources

Scheduled and monitored all maintenance activities of SQL Servers including database consistency check, and index defragments

Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities

Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach

Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers

Implemented and maintained high availability solutions for production servers using mirroring, replication, log shipping, clustering at SQL server 2008.

Designed and developed reports using SQL server reporting services.

Modeled fact and dimension Tables using SQL server analysis services

Designed and constructed data marts and data views using SQL server analysis services.

Environment: SQL server 2012, SQL server 2008 R2, Windows Enterprise Server 2008

JPMorgan Chase, Houston, TX 10/2011 – 11/2012

SQL Server DBA

JPMorgan Chase & Co. is a leading global financial services firm. My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of databases in GTI production, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse. Furthermore, responsible to design and implement databases including tables, relationship, stored procedures, views, user-defined functions, triggers, complex queries, and the indexes for mission-critical business applications. Also responsible to monitor and tune large databases for performance and availability, modify database structures, develop database backup/recovery procedures, and provide support and guidance to operational models.

SQL server 2008/2008 R2 became main version in JPM chase, all our main jobs are around these versions include installation and maintains

Installed and configured new SQL servers according applications’ requirements including SSRS or SSAS using BBDA (Gridapp)

Monitored and tuned databases to meet the performance and availability requirements.

Provided support to business operational models, including off-hour support

Developed, modified, and optimized very complex queries to data retrieval and modification

Generated test data and tested database to meet the functionalities deliverables

Generated database SQL scripts and deployed databases including installation and configuration

Ensured the databases updated accurately and regularly

Configured client/server network libraries

Managed indexes and locks and troubleshoot deadlocks

Devised, developed and implemented disaster recovery and archiving procedures

Planned and co-coordinated database security measures

Communicated regularly with internal technical staff to ensure the database integrity and security

Created and updated database document

Supported development effort by providing T-SQL statement tuning and optimize data loading processes

Maintained day to day operating procedures for SQL Server databases

Provided back-end support for functional testing and performance testing

Scheduled and monitored all maintenance activities of SQL Servers including database consistency check, and index defragments

Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities

Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers

Implemented and maintained high availability solutions for production servers using mirroring, replication, log shipping, clustering at SQL server 2008 and 2005.

Environment: SQL server 2008 R2, SQL Server 2008, Windows Enterprise Server 2003, 2008

Chally Group, Dayton, Oh 06/2011 – 09/2011

SQL server Architect

Chally group is a global leadership and sales potential and performance measurement firm, utilizing its industry leading research, predictive analytics and advisory services to ensure clients have the vital information to minimize risk associated with making critical talent management decisions relating to selection, alignment, development and succession planning. My responsibility in this project included one new database design/implementation and ETL design/implementation.

Interviewed all business users in current system include high management, sale person and developers.

Analyzed current database how data was used in current system.

Initialized table schema diagram from current database which will support current analysis.

Initialized database requirement document.

Designed ERD for the new database.

Designed table schema for the new database from ERD.

Created new database from the physical design.

Designed/create indexes for the tables of the database.

Designed mechanism importing data from the old database to the new database.

Created SSIS packages importing new data to the new database at daily basis.

Measured/tuned the performance of the new database.

Played an important role designing the RAMS (new reporting tool)

Played a leader role in database design/implementation.

Environment: SQL Server 2008 R2, Microsoft Visio 2010, Windows Enterprise Server 2003, 2008

Southen Union, Houston, TX 02/2011 – 05/2011

SQL Server DBA

Southern Union is engaged primarily in transportation, storage, gathering, processing and distribution of national gas. My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of databases in production, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse. Furthermore, responsible to design and implement databases including tables, relationship, stored procedures, views, user-defined functions, triggers, complex queries, and the indexes for mission-critical business applications

Provided support to business operational models, including off-hour support

Modified database structures to support application enhancements.

Generated database SQL scripts and deployed databases including installation and configuration

Configured client/server network libraries

Devised, developed and implemented disaster recovery and archiving procedures

Communicated regularly with internal technical staff to ensure the database integrity and security

Created and updated database document

Supported development effort by providing T-SQL statement tuning and optimize data loading processes

Maintained day to day operating procedures for SQL Server databases

Provided back-end support for functional testing and performance testing

Developed scripts to migrate data from multiple sources

Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities

Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers

Designed and constructed data marts and data views using SQL server analysis services.

Environment: SQL server 2005, SQL server 2008, SQL Server R2 Windows Enterprise Server 2003, 2008

JPMorgan Chase, Houston, TX 06/2009 – 01/2011

SQL Server DBA

SQL server 2008/2008 R2 became main version in JPM chase, all our main jobs are around these versions include installation and maintains

Installed and configured new SQL servers according applications’ requirements including SSRS or SSAS

Monitored and tuned databases to meet the performance and availability requirements.

Provided support to business operational models, including off-hour support

Modified database structures to support application enhancements.

Developed, modified, and optimized very complex queries to data retrieval and modification

Generated test data and tested database to meet the functionalities deliverables

Created the lookup tables and generated the lookup data to meet the specification

Generated database SQL scripts and deployed databases including installation and configuration

Ensured the databases updated accurately and regularly

Configured client/server network libraries

Managed indexes and locks and troubleshoot deadlocks

Devised, developed and implemented disaster recovery and archiving procedures

Planned and co-coordinated database security measures

Created and updated database document

Maintained day to day operating procedures for SQL Server databases

Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers

Solid SQL Server 2008 experience including installation, configuration, management

Server migration from SQL server 2000 or SQL server 2005 to SQL server 2008

Environment: SQL Server 2000, SQL server 2005, SQL server 2008 Windows Enterprise Server 2003, 2008

Exxonmobil Corporation, Houston, TX 04/2007 – 06/2009

SQL Server DBA

ExxonMobil is the world’s largest public traded international oil and gas company, providing energy that helps underpin growing economies and improve living standards around the world. My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of all CO databases in production, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse. Furthermore, responsible to design and implement CO databases including tables, relationship, stored procedures, views, user-defined functions, triggers, complex queries, and the indexes for mission-critical business applications.

Installed and configured new SQL servers according applications’ requirements including SSRS or SSAS

Monitored and tuned databases to meet the performance and availability requirements.

Provided support to business operational models, including off-hour support

Generated genesis document and created the installation code for SQL server 2000 Reporting services.

Initialed the genesis document for SQL server 2005 encryption.

Administrated severs and databases following Exxon Mobil standards and matching UIA (Universal Identity Access) requirements including DB security, audit and risk management.

Developed, modified, and optimized very complex queries to data retrieval and modification

Generated test data and tested database to meet the functionalities deliverables

Created the lookup tables and generated the lookup data to meet the specification

Generated database SQL scripts and deployed databases including installation and configuration

Managed indexes and locks and troubleshoot deadlocks

Maintained day to day operating procedures for SQL Server databases

Provided back-end support for functional testing and performance testing

Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers

Implemented and maintained high availability solutions for production servers using replication, log shipping, clustering or mirroring at SQL server 2000 and 2005.

Designed and developed reports using SQL server reporting services.

Environment: SQL Server 2000, SQL server 2005, SQL server 2008 Windows Enterprise Server 2003

Washington Mutual, Seattle, WA 03/2006– 03/2007

SQL Server DBA

Washington Mutual are building America’s leading retailer of financial services for consumer and small businesses. Customer Optimization project aims to select out the valuable customers from different customer lists. They import data to SQL servers from different data sources. My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of all CO databases in production, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse. Furthermore, responsible to design and implement CO databases including tables, relationship, stored procedures, views, user-defined functions, triggers, complex queries, and the indexes for mission-critical business applications

Monitored and tuned databases to meet the performance and availability requirements.

Generated test data and tested database to meet the functionalities deliverables

Generated database SQL scripts and deployed databases including installation and configuration

Devised, developed and implemented disaster recovery and archiving procedures

Supported development effort by providing T-SQL statement tuning and optimize data loading processes

Maintained day to day operating procedures for SQL Server databases

Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities

Competent to work at the highest level of all phases of database management

SQL Server 2005 installation, configuration, management

Migrating existing applications/servers from SQL server 2000 to 2005 and transferring DTS packages to SSIS programs.

Environment: SQL Server 2000, Windows Enterprise Server 2003, BizTalk Server 2004, Windows SharePoint Service 2.0, IIS 6.0, MSMQ, C#, .NET, Erwin and Microsoft Visio 2000

EDUCATION/CERTIFICATION

M.S. Computer Science, DePaul University, Chicago, IL

B.S. in Electrical Engineer, Northwestern Polytechnic University, Xian, China

Microsoft Certificated Solutions Associate: SQL server 2012/2014

AWS Certified Cloud Practitioner

Contact this candidate