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.

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

Sr. Gatekeeper DBA/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.

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.

Have overall responsibility for Data architecture and Governance from an ILI enterprise perspective.

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 management.

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

Led a team to develop applications via MongoDB and.Net framework/web services to Cloud platform.

Involved IT architect design and server management including API integration, REACT, .Net, Jira GITHUB.

Review of all new software and 3rd party tools.

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

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

Environment: SQL Server 2005/2008/2008R2/2012,RDBM,MongoDB,Windows 2003/2008R2/2016 Server, Cold Fusion, .NET. API, REACT.

Merrill Lynch (Bank of America), Jersey City, New Jersey 6/2009 – 8/2010

Sr. SQL Server DBA/SSIS Developer

Company: Merrill Lynch is one of the world’s premier providers of wealth management, securities trading and sales, corporate finance and investment banking services.

Project: The project is to perform various tasks and roles for QA team perform testing & development support in a daily based. My major roles were included to design SSIS packages for automating its ETL data migration, data comparison and performance tuning, QA development environment support.

Responsibilities:

Designed and developed SSIS packages for automating QA ETL process.

Managed/ implemented/designed SQL servers for QA teams.

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

Managed user access and security tasks.

Created and managed new security accounts.

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

Validated change requests and made appropriate recommendations. Standardized the implementation of data.

Updated the statistics for databases and indexes.

Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

Refresh database environments.

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

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

Configured SSIS packages to run on different environments.

Assisted with various ad hoc query requests.

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

Participated QA testing design and troubleshooting by using various QA methods such as black/white box.

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

Acting liaison between users, developers, and management.

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

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

Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.

Review of all new software and 3rd party tools.

Environment: SQL Server 2005/2008/2012, Windows 2012 Server, TFS, Oracle 9.2/10g, SQL PLUS, DB2, UNIX (Sun Solaris), Sybase, Toad, QC, QTP.

American Psychological Association, Washington D.C. 5/2007 – 5/2009

Sr. SQL Server DBA

Company: The American Psychological Association (APA) is the foremost scientific organization and professional society for psychologists in the United States

Contact this candidate