Sr.DATA ENGINEER/DATA ARCHITECT&DEVELOPER/DBA

(*)Over 23 years IT working experience, 20+ year’s solid working experience in SQL Server/Oracle database administration, data modeler, architect, development and performed with DBA/DB Engineer duties all in enterprise environment.

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

(3)Current Industry knowledge of forward-looking data technologies (Big Data, Hadoop, Spark, MongoDB, In memory DB's and streaming data)

(4)Broad knowledge of Agile project methodology and ITIL best practices

(5)Master Data Management platforms and practices

(6)Experience with Cloud computing concepts (private, public and hybrid)

(7)Ability to partner and collaborate across organizations to craft innovative solutions that drive customer-centric outcomes.

(8)Ability to think strategically and translate plans into phased actions in a fast paced, high pressure environment.

(9)Strong presentation skills necessary to communicate with, and persuade, a wide range of audiences

(10)Experience with scaled systems and understanding of data and system integration.

(11)Have a good understanding of security and cyber-security from a data and process perspective.

(12)Customer-driven mindset and insatiable appetite for engineering excellence and drive for outcomes

(13)Well versed in Industry and Non-Industry trends in technology and business, to provide actionable insights for remaining competitive with technology solutions.

(14)Designed and developed SSIS packages for ETL data to various environments for supporting SSRS/SSAS.

(15)Install, Configure, and manage SQL 2000/2005/2008/2012/2014/2019 Servers, Migrate existing applications to SQL 2005, Transfer/Rewrite DTS packages to SSIS programs.

(16)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 including high availability clustering environment.

(17)Direct work with development team and provide full SDLC process support including specific QA functional/performance testing.

(18)Solid knowledge and working experience in the following areas (in details):

Support for both production and development databases.

Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multi-tier applications.

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

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

Designed and created SSIS packages for ETL process from multiple heterogeneous data sources.

Configured SSIS packages to run on different environments for SSRS Dimensions and Facts tables.

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

Scripts and stored procedures with SQL validation.

Resolving database performance issues, tuning issues, database capacity planning issues.

SQL Management Studio, RDBM,SQL Enterprise Manager and Query Analyzer, Analysis Services, Profile.

Expertise in performing administrative tasks: database files management, backup/restore, security management, data integration and synchronization.

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

Configured security and access to product databases in SQL Server 2014, Windows Server.

Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipated technological innovations.

ETL data feeds from multiple data sources including MySQL, Oracle, Flat file, XML, spreadsheet, etc.

T-SQL coding and testing functions, views, triggers, cursors, dictionary, stored procedures, etc.

Data transferring including DTS packages, SSIS packages, replication, log shipping.

Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering.

Solid background in Finance, banking, and marketing services field.

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

Devised, developed, and implemented disaster recovery policies and archiving procedures.

(19)Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks.

(20) Excellent communication skills, proactive, independent, self-managing and teamwork spirits.

AREAS OF EXPERTISE

Category

Technology

Database

SQL Server 2005/2008/2012/2016/2019/2022, RDBM, MySQL 5.5/5.7, MongoDB

T-SQL, SQL, PL/SQL, SQL*PLUS, SQL Server Service Broker

Performance Tuning, Capacity Planning

Installation, Upgrade, & Migration

ODBC, JDBC, OLE DB, DTS, SSIS, SSRS, SSAS

SQL Server 2012/2014/2016/2019 Enterprise Edition, Oracle 10g/11g

T-SQL, PL/SQL, OBIEE, OWB, ODI, SAP

Operating Systems

Windows 2012//7/10,Powershell scripts, UNIX Shell Scripting, Python

Windows Azure, Microsoft SQL Azure

Applications

Erwin 7.1/7.3/8/9.5/9.6 Modeler, ER/Studio, Enterprise Architect 2.0

Elipse, TFS, ADO. NET Entity Framework, MS Sharepoint 2019, RDBMS, Jira, Confluence, Github, CI/CD, API Integration, REACT, Docker

Red Gate, LiteSpeed, Toad, Idera Diagnostic Manager, SQLsafe, Admin Tools.

Visual Studio 2010/2013/.NET, Macromedia (Flash, Firework, Shockwave)

Language

C#, Java, .NET, Cold Fusion, COM+, VB, XML, ASP.NET, JavaScript, TSQL

Protocols

HTTP, TCP/IP, FTP, Cloud Computing, SQL Azure, AWS Clouding

WORKING EXPERIENCE

US Air Force DOD, Nellis AFB, Las Vegas NV 02/2024 – Current

Sr. Database Consultant

Company: The US Air Force is the air service branch of the US Armed Forces and is one of the eight uniformed services of the United States. It is a military service branch organized within the Department of the Air Force, one the three military departments of the Department of Defense.

Project: The F-35 Joint Strike Fighter is a 5th generation multi-role aircraft developed for the US Navy, Marine Corps, and Air Force. The project is involved to design and develop an AI & ML enabled database system to improve an analytic framework for evaluating the F-35 lethality kill chain against air and surface targets.

Responsibilities:

Collecting and analyzing the final requirements and specifications of the project.

Leading the database architecture and framework design and implementation.

Designing databases conceptual diagram, logical diagram and physical diagram.

Leading and setting up SQL Server and Apache Hadoop hardware architecture and software configuration.

Communicating with different levels of analysts/users to clarify data history and performing a data mapping process.

Analyzing data source packages and designing the ETL ingestion pipeline framework process.

Working with a testing team by applying scrum CI/CD method.

Performing database consultant roles like data architect, database developer and database administrator, etc.

Environment: SQL Server 2016/2019/2022, Oracle, Apache Hadoop, Erwin 8 Data Modeler, RDBMS, NoSQL Big Data, Stitches, Cheetas, GitLab.

Naval Nuclear Laboratory/DOE/DOD, Idaho Falls, ID 10/2023– 01/2024

Sr. Database Consultant

Company: Until 1995, NRF operated prototype reactors to train nearly 40,000 Navy personnel, as well as for testing purposes. The NRF receives, examines, and prepares Naval spent nuclear fuel for storage, in addition to preparing and examining irradiated test specimen assemblies; also collecting engineering data on nuclear reactor environments, material behavior, and design performance, etc.

Project: The project is to build and develop an information system by implementing “Building Information Modeling” (BIM). As a senior database specialist, the major responsibility is to design and implement a SQL Server database system to support the BIM project. The tasks are included requirements collection, feasibility analysis, conceptual design, logical design and physical schema design; data migration from various data sources to target database system in data center and Azure cloud. Also participated the whole web system from front to back end design and implementations. Technologies are involved 3D models, GIS and FME/Revent, etc.

Responsibilities:

Defining project scope and collecting requirements and feasibility analysis.

Design databases conceptual diagram, logical diagram and physical diagram.

Led and Set up SQL Server hardware architecture and software configuration with the team.

Prepare and ETL all sources data to final staging destinations by using FME and ArcGIS.

Generating dashboards and visualizations by using Azure Databricks.

Managing security, governance, high availability, and disaster recovery, Data discovery,

Communicating with different level of end-users to clarify data history and performing a data mapping process.

Environment: SQL Server 2014/2016/2019/2022, SQL Azure, C#, Azure Databricks, Erwin 8 Data Modeler, RDBMS, Arc GIS, 3D models, FME, Revent, Windows 10 Server, Jira CI/CD, Confluence, GitHub.

Deloitte/US Army/Leidos/Navy DOD, San Diego CA 1/2022– 8/2023

Sr. Database Engineer

Company: The United States Army is the land service branch of the United States Armed Forces. Deloitte is a multinational professional services network with offices in over 150 countries and territories around the world. Deloitte in Washington DC branch is a government services contractor focused on delivering valued services to its customers in many areas.

Project: The project is to develop and support the military educational system by applying innovative technologies as one of the Army Modernization processes. As a senior database engineer, the major responsibility is to support the database ETL system. The tasks are involved data management including reviewing and redesigning data models, ETL data from Oracle/MongoDB/MySQL to target SQL Server system including using IBM DataStage/Toad and performance tuning, conceptual, logical, and physical schema design, data migration to Azure cloud or SQL Azure, data mapping, and troubleshoot any database related issues.

Responsibilities:

Maintain and update ETL packages by using DataStage tool based on the Jira/Git/CI/CD system.

Review Data models and data architectures including building relational schema databases.

Design and develop SSIS packages for ETL data to various target tables in Azure Databricks.

ETL data feeds using SSIS from multiple data sources to Azure BLOB storages including Flat file, XML, spreadsheet, etc.

Handled common database procedures such as upgrade, backup, recovery, migration, etc.

Backup and restore databases; develop backup strategies and restore procedures, job scheduling by using.

SQL Server 2005/2008/2012/2019 Management Studio.

Managed user access and security tasks and created and managed new security accounts.

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

Updated the statistics for databases and indexes.

Design, set up and supported SSRS server environment and developed dimension and fact tables.

Designed and created SSIS package for ETL process from multiple heterogeneous data sources.

Managed and provided high availability SQL Server 2016/2019 including Always-on, replication and SQL Server clustering.

Update data model ERD and data dictionary changes for each agile scrum cycle.

Design and review Databases, Data Warehouses and Multidimensional Databases.

Analyze any database schema RDBM or DDL changes and issues.

Provide T-SQL codes for updating system changes from functional developers.

Handled common database procedures and data management such as upgrade, backup, recovery, migration.

Closely work with application development team for any database related tasks.

Environment: SQL Server 2014/2016/2019, SQL Azure Cloud Databricks, Neo4J, MongoDB, AWS, Erwin 7.3/8 Modeler, EA modeler, RDBMS, SAP, Windows 10 Server, Jira CI/CD, Confluence, GitHub.

ARROW INTERNATIONAL, INC. Cleveland, OH 7/2021 – 1/2022

Director of Data Systems Department

Company: Arrow International, Inc. is the world’s largest manufacturer and distributor of charitable gaming products, including pull tabs, electronic pull tabs, bingo products and electronic bingo devices for charitable gaming. Headquartered in Cleveland, Ohio, Arrow has approximately 1,200 employees across four manufacturing facilities and a network of 60+ distribution facilities.

Roles & Responsibilities: As a Department Director, is responsible for managing a company’s database and ensuring the safety and security of all data to prevent unauthorized access and information risk. Coordinated with data engineers, database administrators, database developers, application developers to design systems that support business functions and operations. The responsibilities are included implementing data handling procedures, organizing data accurately, disposing of outdated data, and reporting system failures; Created database management policies and data governance including database best practices documents and database Gatekeeper processes, etc.

Making sure the next generation data and analytics platform for the company of its business. Data architecture and quality assurance are the critical responsibility - requiring real hands-on experiences and modernize legacy data architecture, instrument measurements, data migrations to Appian/AWS and define strategies to reduce data redundancy. Partner with the Data strategy team for providing strategic thought leadership and measurable, defined outcomes in data strategy and insight and encompassing delivery of products in a defined suite. My role is the combination of Data Architect, Database management, Data Analysis, Data Migration Tools Knowledge, Data Modeling, Data Integration, Data Warehousing, Database Design, etc.

Responsibilities:

Communicating effectively across the organization to ensure alignment to the business objectives.

Designed Data models and data architectures including building relational schema databases.

Led company network infrastructures to improve data system performance.

Overseed the company’s databases, ensuring their proper functioning, security, integrity and reliability.

Led, mentor and manage the data implementation team, ensuring optimal performance.

Collaborated with leadership on annual resource planning & budgeting to optimize data operations optimization.

Hired, trained, mentored and grew data implementation team/talents.

Worked closely with VP-CTO to align data implementation strategies with overall company goals.

Implemented measures to safeguard data, prevent unauthorized access, and mitigate information risk.

Collaborated with data engineers and other software departments to design systems that support business operations and functions daily.

Diagnosed performance issues and provided tuning solutions with database and capacity planning strategies.

Established procedures for organizing, storing, and retrieving data accurately including backup-restore strategies, disaster recovery polices, high availability frameworks.

Owned day to day management and governance of data implementations across multiple clients/projects.

Led efforts to enhance storage/network infrastructures and optimize data system performance.

Maintained data integrity, security, and efficient operations within an organization.

Environment: Reporting tools dashboard, AWS/Azure, SQL Server 2008R2/2014/2016/2019/2022, RDBMS, MySQL 5.7, 8.0., Erwin 7.3/8 Modeler, Data management/governance, Python, Jira CI/CD, Confluence.

US Department of Transportation, Washington D.C. 7/2017 – 1/2022

Sr. Gatekeeper DBA Lead/Data Architect

Company: The Federal Transit Administration (FTA) provides financial and technical assistance to local public transit systems, including buses, subways, light rail, commuter rail, trolleys and ferries. FTA also oversees safety measures and helps develop next-generation technology research.

Roles & Responsibilities: Responsible for creating database management policies including database best practices documents and database Gatekeeper processes, etc. Making sure the next generation data and analytics platform for FTA of its business. Data architecture and quality assurance are the critical responsibility - requiring real hands-on experiences and modernize legacy data architecture, instrument measurements, data migrations to Appian/AWS and define strategies to reduce data redundancy. Partner with the Data strategy team for providing strategic thought leadership and measurable, defined outcomes in data strategy and insight and encompassing delivery of products in a defined suite. My role is the combination of Data Architect, Database management, Data Analysis, Data Migration Tools Knowledge, Data Modeling, Data Integration, Data Warehousing, Database Design, etc.

Responsibilities:

Provide technical design leadership with the responsibility to ensure the efficient use of resources, the selection of appropriate technology and use of appropriate design methodologies.

Wrote Database design, ERD design and Erwin design best practice documents.

Wrote Database, ERD and Erwin design best practice checklists.

Managed a database team with 7 people for daily operations and tasks.

As a release manager to responsible for all deployments to preprod and production environment

Define various data sources and data destinations for data mapping documents, etc.

Deep understanding of master data management architecture and applications

Ownership refers to driving both the data architecture and governance for the operational and analytical data environments, data consumption patterns and design to achieve desired business outcomes.

Constructing a holistic view of the data infrastructure needed to run the business and collaborate with technology and business partners to incorporate that into their roadmap.

Developing a long-term vision for creating a cloud-wide reporting and analytics infrastructure

Collaborating with the Data strategy team to define third party data acquisition strategy to support business needs.

As a Release Manager, responsible for preprod and prod deployment each week with sprint agile schedules.

Strategic planning and execution of all aspects of data architecture including establishment of current and future state architecture and transformational roadmap in alignment with business strategy.

Role model technology-leadership by encouraging adoption of tools and solutions that solve for business in a cheaper and faster manner.

Communicating effectively across the organization to ensure alignment to the business objectives. Designed Data models and data architectures including building relational schema databases.

Developed strategies for data acquisitions, archive recovery, and implementation of a database.

Diagnosed performance issues and provided tuning solutions with database and capacity planning strategies.

Designed and reviewed Databases, Data Warehouses and Multidimensional Databases

Wrote and optimized in-application SQL statements by TSQL and dynamic TSQL.

Lead troubleshooting effort for any database and data architect problems and issues multiple projects for FTA. Analyzing any database schema RDBM or DDL changes and issues

Environment: AWS/Appian, SQL Server 2008R2/2014/2016/2019, RDBMS, MySQL 5.7, 8.0., MongoDB, Erwin 7.3/8 Modeler, Data management/governance, Appian, Python, Jira CI/CD, Confluence, Bitbucket, GITHUB.

American Systems, Washington D.C. 4/2016 – 3/2017

Sr. Database Engineer II

Company: American Systems is a government services contractor focused on delivering valued services to its customers in areas of National Priority.

Project: The project is to rebuild and redesign the military childcare system by applying innovative technologies. As a senior database engineer the major responsibilities is to migrate the database system from MySQL to SQL Server 2014 including data warehouse dimension/fact tables. The tasks are involved reviewing and redesign data models, ETL data to target SQL Server system (SSRS) including using SSIS packages and performance tuning, conceptual, logical and physical schema design, ETL data migration, data mapping, and troubleshoot any database related issues.

Responsibilities:

Designed Data models and data architectures including building relational schema databases.

Developed strategies for data acquisitions, archive recovery, and implementation of a database.

Diagnosed performance issues and provided tuning solutions with database and capacity planning strategies;

Designed and reviewed Databases, Data Warehouses and Multidimensional Databases with RDBMS.

Designed and developed SSIS packages for ETL data to various environments for supporting SSRS.

Wrote and optimize in-application SQL statements by TSQL and dynamic TSQL.

Troubleshooting any database and data architect problems and issues including SSIS, SSRS and SSAS.

Provided T-SQL codes for updating system changes from functional developers.

Prepared documentations and specifications for applications including Reporting & MS SharePoint servers.

Handled common database procedures such as upgrade, backup, recovery, migration, etc.

Analyzing any database schema or DDL changes and issues

Configure & perform administrative tasks for SQL Server 201/2019 and SharePoint server systems.

ETL data feeds from multiple data sources including MySQL, Oracle, SharePoint, Flat file, XML, spreadsheet, etc.

Closely work with application development/testing team for any database related tasks

Verified and validated testing tickets with all databases related use cases and tasks.

Assisted with various ad hoc query requests for reporting.

Reviewed and designed database management system and polices including disaster recovery and virtualization.

Environment: SQL Server 2012/2016/2019, Erwin 7.1/7.3/8 Modeler, EA modeler, Windows 2019, C#, .NET, TFS, MS SharePoint 2019, RDBM,SAP, Microsoft SQL Azure, Eclipse, MySQL.

U.S. Department of Housing and Urban Development. Washington D.C. 11/2014 – 3/2016

Sr. Database Developer

Company: U.S. Department of Housing and Urban Development (HUD) is working to strengthen the housing market to bolster the economy and protect consumers; meet the need for quality affordable rental homes; utilize housing as a platform for improving quality of life; build inclusive and sustainable communities free from discrimination and transform the way HUD does business.

Project: As a senior database developer, the major responsibilities are maintaining and supporting its budget financial application including conceptual, logical and physical schema design, data migration, data mapping, and troubleshoot any database related issues. Worked at multi-platforms with multithreading layers and wrote PL/SQL Oracle and SQL Server development environments.

Responsibilities:

Wrote and optimize in-application SQL statements by TSQL and PL/SQL

Provided T-SQL codes for updating system changes from functional developers.

Prepared documentations and specifications

Handled common database procedures such as upgrade, backup, recovery, migration, etc.

Analyzing any database schema or DDL changes and issues

Closely work with application development team for any database related tasks

Assisted with various ad hoc query requests for reporting.

Troubleshooting any database and data architect problems and issues

Reviewed and designed database management system and polices including disaster recovery and virtualization.

Backup and restore databases; develop backup strategies and restore procedures, job scheduling by using SQL Server 2019 Management Studio.

Managed user access and security tasks and created and managed new security accounts.

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

Refresh database environments.

Developed and implemented database and best practices, improving performance and maintainability of corporate databases.

Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipated technological innovations.

Configured SSIS packages to run on different environments.

Designed and created SSIS package for ETL process from multiple heterogeneous data sources.

Modified database structures as directed by developers and assisted with coding, design and optimization.

Standardized the implementation of data.

Involved IT architect design and server management.

Review of all new software and 3rd party tools.

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

Environment: SQL Server 2012/2016/2019, Oracle 10g/11g, Erwin 7.1/7.3/8 Modeler,Windows 2019 Server, C#, .NET, VB, TFS, MS SharePoint 2019,Microsoft SQL Azure, Linux, MySQL.

MILLENNIUM CHALLENGE CORPORATION, Washington D.C. 2/2014 – 11/2014

Data Architect

Company: The Millennium Challenge Corporation (MCC) is an innovative and independent U.S. foreign aid agency that is helping lead the fight against global poverty.

Project: As a senior SQL Server DBA and developer background, the major responsibilities are maintaining and supporting its MIS financial application. Working at multi-platforms with multithreading layers and C#.net development environments.

Responsibilities:

Work closely with the users, systems designers and the developers on a project team.

Manage and control each new release.

Closely work with application development team for any database related tasks

Troubleshooting any database and data architect problems and issues

Reviewed and designed database management system and polices including disaster recovery and virtualization.

Backup and restore databases; develop backup strategies and restore procedures, job scheduling by using SQL Server 2005/2008/2012/2019 Management Studio.

Managed user access and security tasks and created and managed new security accounts.

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

Updated the statistics for databases and indexes.

Developed and implemented database and best practices, improving performance and maintainability of corporate databases.

Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipated technological innovations.

Configured SSIS packages to run on different environments.

Design, set up and supported SSRS server environment and developed dimension and fact tables.

Designed and created SSIS package for ETL process from multiple heterogeneous data sources.

Assisted with various ad hoc query requests for reporting.

Provided back-end support for functional testing and performance testing.

Modified database structures RDBM as directed by developers and assisted with coding, design, and optimization.

Validated change requests and made appropriate recommendations.

Involved IT architect design and server management.

Review of all new software and 3rd party tools.

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

Environment: SQL Server 2012/2016/2019, MySQL 5.5/5.7,Windows 2019 Server, C#, .NET, MS TFS, Eclipse.

US COURTS, Washington D.C. 9/2010 – 1/2014

Sr. SQL Server DBA/Developer

Company:The U.S. Courts are an independent, national judiciary providing fair and impartial justice within the jurisdiction conferred by the Constitution and Congress. IT Application Service Branch serves over 7000 Judges internally and is located center of downtown Washington D.C.

Project: As a senior SQL Server DBA, the major responsibilities are maintaining and supporting over 25 Cold Fusion and .Net applications for 7000+ Judges to use in a daily based across over United States.

Responsibilities:

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

Reviewed and designed database management system and polices including disaster recovery and virtualization.

Backup and restore databases; develop backup strategies and restore procedures, job scheduling by using SQL Server 2005/2008/2012 Management Studio.

Managed/ implemented/designed SQL servers for all users.

Managed user access and security tasks and created and managed new security accounts.

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

Refresh database environments.

Updated the statistics for databases and indexes.

Converted legacy system to a new Remedy application system.

Developed and implemented database and best practices, improving performance and maintainability of corporate databases.

Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipated technological innovations.

Designed and developed new SSIS/SSRS packages for BI data warehouse/dimension tables.

Configured SSIS packages to run on different environments.

Design, set up and supported SSRS server environment and developed dimension and fact tables.

Designed and created SSIS package for ETL process from multiple heterogeneous data sources.

Assisted with various ad hoc query requests for reporting.

Provided back-end support for functional testing and performance testing.

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

Acting liaison between users, developers and

Contact this candidate