We provide IT Staff Augmentation Services!

Senior Database Engineer Resume

4.00/5 (Submit Your Rating)

Wilton, CT

SUMMARY

  • Results oriented professional with 12 years of progressive experiences in Information Technology from various industries. Extensive experience across database technology including SQL Server, Azure SQL databases and Oracle.
  • Technical expertise in the design, implementation, administrator, Security and maintenance of Relational Database Management Systems (RDMBS). As Data Modeler, Participate in logical and physical database design for OTPL, ODS, EDW and Financial data warehouse (FDW). Integrated third party Enterprise application CRM package.
  • Very strong in SQL/T - SQL development, stored procedures, triggers, indexes, tables, SQL performance tuning, SSIS packages, SSRS, PL/SQL and PowerShell, Python for the automation. ETL and Data Extraction.
  • Proficient in Windows operating systems, VMware, AD security, SAN infrastructure related to Database storage, Always-on, Hyper-V, SCCM. Knowledgeable in Azure\AWS cloud, NoSQL Database, Big Data Technologies and Python.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2017-2000, Azure SQL, Oracle 12c-8.x, AS400 DB2, MySQL, Sybase and MS Access

Cloud: Microsoft Azure and Amazon AWS

Platforms: Microsoft Windows, Unix, Ubuntu, windows Systems for Linux (WSL).

Microsoft SQL Server Tools: Microsoft SQL Server Management Studio, Azure Data Studio, BIDS, Visual Studio (SSRS, SSIS, SSAS), Extended Event, SQL Server Profile, Trace, Data Profile Viewer, DB Engine Tuning Advisor, Query Store. DBArtisan, Solarwind spotlight.Senturyone (monitor and event chain)

Oracle Tools: Oracle Enterprise Manager l, Database Control, Net Configuration Assistant, Network Manager, Database Configuration Assistant, SQL Developer, SQL* Plus, SQL Loader, Recovery Manager, Data Pump Utilities.

Data Modeling: Erwin, ER Studio, TOAD Data Modeler, Microsoft Visio

Languages: SQL, T-SQL, PL/SQL, PowerShell, Python, VBScript, BATCH, Shell Scripting, XML, C#, R, VBA

Reports Builder: Power BI, Visual Studio for BI stack, SSRS Report Builder, Crystal Reports, Toad, nVision, PS Query.

Analytical Tools: Power BI, MS Excel, Power Query, Power Pivot, QlikView.

CRM: PeopleSoft Financial ERP (AP,GL,AR, AM), Oracle Financial SAGE HRMS, Workday

PROFESSIONAL EXPERIENCE

Senior Database Engineer

Confidential, Wilton CT

Responsibilities:

  • Provides technical assistance Design and Develop logical\physical database design and maintains.
  • Hardware/software upgrades- POC and testing for standard vs enterprise and on premise vs cloud, Setting the test environments, baseline, performance and report using agile methodologies
  • Manages and maintains data distribution using 50+ replications and SSIS packages in all prod and mom-prod servers
  • Designs and implements database back up, recovery, archiving strategies for physical databases.
  • Nightly Financial refresh process, data aggregation, batch reporting and ETL data extract using sentry one event chain, SQL agent jobs and windows jobs.
  • Manages Capacity Planning; Monitoring and Tuning; SQL Analysis; Security Administration
  • Conduct application and server performance tuning using logicmonitor. Improve database performance using extended Event, Query Store, DMV queries and sentyone performance analysis tools.
  • Perform and manage database administration to ensure database availability and enable the proper database monitoring using sentyone enterprise tools.
  • Manage and deploy replication server and SQL Clustering solutions supporting both disaster recovery and applications
  • Perform weekly deployment to SQL Azure and legacy application.

Senior Database Engineer

Confidential, Stamford CT

Responsibilities:

  • Install, architect, configure, patch, optimize and monitor enterprise wide 100+ SQL server instances, 15 Database mirroring, 11 SQL Server Clusters, 8 integration services, 4 Reporting Services, 4 replications and 1 Analysis services.
  • Design and Develop logical\physical database design and maintains. Perform weekly deployment and hotfixes.
  • Managed Windows and SQL Clustering for mission critical physical systems. Use DB Mirroring for high availability.
  • Implement and maintain database backup, recovery and archiving strategies for physical database, Provide standard regrading data access and database security. Manage database Security with AD Groups and services account.
  • Conduct database/Server tuning to improver in-house application and PeopleSoft ERP to optimize performance.
  • Monitor system with Solarwind spotlight, Homegrown monitoring system PowerShell with DBATools modules.
  • Capture baseline and analysis performance data for performance tuning opportunity using these toolset; PAL, SQL trace, SQL Profile, DiagManager, SQL Nexus, XEvent, diagnostic DMVs, SQL SentryOne Plan Explorer.
  • Support financial batch: PeopleSoft daily jobs, FTP Interface, Claims File automation and IBNR\nVision reporting. Perform Month-end close process for financial reporting using genius AS400, MSSQL Server (SSIS, SSRS).
  • Setup automation with PowerShell to check the Database/server configurations, nightly database restore, deploy nVision layouts. Use SQL agent job and Database mail for error alerting, Database detail, Job History and Job failed.
  • Build custom report (SSRS) with SSCM, package SSMS software for on-demand deployment
  • Knowledge of Transparent Data Encryption, Data encryption, Configuring Always Encrypted, Dynamic data masking
  • Perform quarterly database refresh for the PeopleSoft ERP. Automate nightly database refresh for production support.
  • Perform Sox Audit by providing evidences of databases and server’s configurations, list of PeopleSoft User Security.
  • 2+ years administering PeopleSoft: Monitor PeopleSoft ERP, User Security, Deployments, Creation/ configuration of PeopleSoft domains, Manage PeopleSoft PUM/Tools upgrade process, tune databases indexes for nVision and servers Patching creating and configuring 3rd party Interfaces into and from PeopleSoft and out/in, to/from other systems
  • Participates in quarterly offsite Disaster Recovery exercise. Provided data center yearly power outage, hardware support, install TPM encryption module for bit locker, racking servers, cabling and maintenance management.
  • Familiar with Azure Cloud Database integration and administration, big data distribution Hortonworks Hadoop cluster.

Senior Database Administrator / Modeler

Data Analyst

Responsibilities:

  • Provide first-level application support: Resolve problems and answer questions related to the MSSQL and Oracle RDBMS and Windows\ Solaris Unix platforms. Facilitate application development and client problem resolution with optimum speed and efficiency. Provide 24 X 7 on-call support and evening after hour support.
  • Install and upgrade database related products: Keep databases at current release and maintenance levels; install supporting products; provide current, stable production and development environments. Worked on SQL 2012 to SQL 2014 upgrade, worked on SQL Server 2005 to 2008R2 to 2012 and applying Service Packs
  • Monitored MSSQL/ORACLE RDBMS using DBArtisan, experience setting up snapshot/transcription Replication.
  • Maintain database backup/recovery environment: Monitor implementation of correct backup strategy; develop backup\recovery model; support data recovery caused by user or system error by quickly to refresh data.
  • Performance tuning stored procedures \ query created by developers by analyzing execution query plans and using SQL Server Profiler, Data Tuning Advisor. Stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling procedures and performing other maintenance tasks.
  • Expertise in troubleshooting database: Check Database consistency using DBCC commands, server configuration, DMV'S, DMF'S, analyzing Locks, Dead Locks, Blocks, Isolation Level and Checking threshold values against baselines.
  • Consolidated the corporate SQL environments from 100 to 75 SQL instances, to reduce SQL licensing cost.
  • Perform quarterly database refresh sync with corporate: Refresh data from Prod environment to Dev/QA/FT; execute necessary tasks to accomplish this, including export, drop, create, and import prescheduled time to minimize downtime;
  • Perform security audit: Design and Test control activity for SOX for the database(s); Prepare and Participates in offsite Disaster Recovery exercise. Assist with documentation and DR manual.
  • Develop utilities to Automate repeated DBA tasks and data collection using PowerShell, VBScript and VBA.
  • Experience in BI Development: Involved in migration of 200+ DTS to SSIS Packages, design deployment of SSIS packages Convert crystal report in SSRS report and Migrated Oracle, Sybase, to an MSSQL by using SSMA

System Analyst / Developer

Confidential, Danbury CT

Responsibilities:

  • Developed software Tracking system (MS Access VBA Front end and SQL Server Back end) which Track PCB thru building Testing, shipping, also developed manufacturing reporting repository (Vb.net) with SSRS and Crystal Report
  • Monitored database maintenance activities: daily database backups, consistency check and index defragmentation.
  • Create DDL script to build database in Access, MySQL, Oracle and MSSQL 2000. Wrote VBScript for the automation.
  • Design normalize data model (Erwin), ER Model and Flow chat (Visio). Worked migration from Access to SQL Server.
  • Experience in extract, transform and load(ETL) data using SSIS and DTS Packages, Import/Export, BCP
  • Write SQL SPs, queries in T-SQL and PL\SQL to analyze data, generate BI Reports in SSRS and Crystal Reports.
  • Support Profitkey Manufacturing ERP (Oracle), Preform backup\restore, indexing, custom reports and daily Batch.

We'd love your feedback!