My Resume…

SUMMARY

SQL Server Database Engineer / Developer with over 10yrs. production experience in 24x7 mid-size corporate environments. Providing database admin / dev support for PostgreSQL, MySQL, Oracle, SQL Server, Sybase, and DB2

SKILLS

Hybrid  Cloud:

AWS (EC2, S3, RDS) / Azure (VM, SQL, Website) / Google (GCP) Administration, ServiceNow, WordPress Multisite Design

SQL Server:

Backup - Restore - Recovery, BCP, Clustering,  Database design, Database Security, Disaster Recovery, Dephix, DMV querying, Functions, High Availability, Index tuning, SQL Server installation,  Mirroring, Patching, Performance tuning, Production On-call 24x7 support, SQL Profiler, Replication, SSAS, SSIS , SSRS, Production deployments, SQL security, SQL Server on AWS, troubleshooting, TSQL, query optimization

Oracle:

Oracle data modeling, Database design and implementation, Database Express, Database tuning, Database logs Compression, Install - Configuration Oracle server software, growth monitoring, Enterprise Manager ,Performance monitoring, Pluggable databases, SQL Developer, Tablespace management

 

Teams:

Cross functional teams size - 35, DBA teams size - 9, SAP team size - 20, Military combat support size - 90 to 18,000 troops

EDUCATION

  • City University of New York
    • BS, Business, AS, Computer Science
  • Polytechnic Institute of New York University (Non Degree)
    • Military Science and Operational Studies
  • US Army (Non Degree)
    • Airborne school - Parachuting taught by 7th Special Forces, Fort Bragg, NC
    • Ranger - Infantry Schools – Military tactics taught at Fort Benning, GA

CERTIFICATIONS

ITIL v3 Foundation, HIPAA compliance certificate, SQL Server Administration 2779-2780, SAP R/3 Security Admin 1940 -1950, OpenText IXOS ECM (Centera) Admin, PeopleSoft 7.5 Security, Salesforce.com Admin ADM-201, SalesLogix CRM Admin, SAP Crystal Enterprise Admin, SharePoint Admin 8036, Vertex - VantageTax Admin

PROFESSIONAL EXPERIENCE

Vantage Benefits Administrators, Inc. - Dallas, TX                                                         MAY 2017 - CURRENT

 SQL Server Database Engineer / Project Manager

  • Amazon AWS Multi-Tenant Production SQL Server database migration and support
  • Database development on VMware, Hyper-V, Windows / Linux environments
  • Database ETL
  • Database reengineering, cloning, data modeling via Idera Data Architect
  • Health benefits Production SQL Server database  upgrade - migration
  • LDAP security authentication
  • Multi-Tenant Dashboard reporting
  • Performance tuning and query optimization
  • Project management and planning
  • SQL Server datatype varchar to Nvarchar conversion in AWS
  • SQL Server standards,  Policies & Procedures

TOOLS: Agile, Amazon AWS (S3, RDS), BitBucket, Mindjet MindManager (Project Management), Idera Data Architect, Jira, Linux (Centos), MS 2012 – 2014, PostgreSQL, SourceTree, Tibco JasperSoft BI Reports (Windows - Linux), Talend ETL

REIDCITY, LLC - McKinney, TX                                                                                                        2016 - 2017

Cloud Systems Admin / SQL Server Database Engineer

  • Cloud hosting services management
  • Cloud Microsoft SQL Server (Windows – Linux – Azure, AWS, GCP) development
  • Corporate website portals design and management
  • Created and managed business project data models
  • CRM database and marketing campaign management
  • On premise to AWS RDS and Redshift database migrations
  • Reverse engineering and data modeling of MySQL,  PostgreSQL and SQL Server data
  • Salesforce.com, Access, MySQL, SQL Server, SAP Sybase  and  Oracle 9i-10g-11i-12c data integration
  • SQL Server replication , High Availability fundamentals training
  • SQL Server to PostgreSQL migration
  • VMware, VirtualBox and Hyper-V virtualization

TOOLS: AWS (S3, EC2, RDS, Redshift), Azure, GCP, Active Directory,  Android Studio,  Erwin, Idera Data Architect, Docker, Linux, MS SQL Server 2008  - 2017 CTP, Oracle 9i - 10g - 11i - 12c, Mindjet MindManager, MySQL, Oracle Data Modeler, PostgreSQL 9x, Sybase 16, ServiceNow( Dev), agile, Splunk, SuiteCRM, SFTP, SSL, WordPress

Safety-Kleen environmental (CLEAN HARBORS) - RICHARDSON / EDS Campus, Plano, TX              1996 - 2016

Production SQL Server Database Admin / Developer - Salesforce, SAP/r3 Security, PeopleSoft, ServiceNow Administrator

  • ADP Oracle Payroll database implementation
  • BizTalk credit card integration projects
  • Capacity planning
  • Clustered SQL Server environments using Delphix, VMware VSphere, Hyper-V and, VirtualBox       
  • Data modeling, reengineering using Erwin, Idera, Visio and Embarcadero
  • Data Warehouse, SharePoint Server databases
  • Database administration and design
  • Database Reverse Engineering, data migrations and upgrades
  • Mirroring, AlwaysOn, Log shipping, transactional replication support
  • Off Shore and local SQL Server DBA teams management
  • On-Call support monitoring / scheduling via  Solarwinds , Idera SQL Diagnostic manager and Autosys
  • PeopleSoft (DB2) to SAP/r3 on SQL Server migration
  • PeopleSoft reporting portal
  • Pervasive ETL and SQL DTS marketing data processes to Salesforce & SSIS migration
  • Policies and procedures and vendor management documentation
  • PowerShell scripting
  • Query performance tuning , Query optimization, SQL profiling, Activity Monitoring
  • Release coordination and Production hotfixes, SSRS reports and SSIS packages deployments support           
  • SAP Content management (OpenText IXOS) and SAP Crystal Enterprise, Sabrix Corporate Tax implementations          
  • SAP/r3 security and PeopleSoft administration and upgrades support
  • ServiceNow administration , development and workflow process automation
  • ServiceNow triaging of support tickets, TFS deployments, patch releases and hotfixes
  • SQL Server and Oracle decommission projects
  • SQL Server backups, maintenance and restores
  • SQL server datacenter environments from Texas to Boston migration
  • SQL Server failover clustered environments patching and upgrades
  • SQL Server replication, disaster recovery support
  • Stored procedures, functions, tables, views, triggers, indexes, constraints
  • Sybase SQL Server on Unix to MS SQL Server migration

TOOLS: Agile, Apache, Autosys, Delphix,  Erwin,  Embarcadero FTP, Hyper-V, IBM AIX, IBM DB2, Idera SQLDM, Informatica, JavaScript, LDAP, Linux (Centos), Mobius, MS Project, TFS, SQL Server 4.21 to 2017 CTP, Visual Studio, Oracle (9i, 10g, 11i), MySQL, Oracle, PeopleSoft, Power BI, PowerShell, Python, R, Redgate Complete Compare, Remedy, Report2Web, a, Salesforce.com, Solarwinds, SAP Crystal Reports - Enterprise, SAP SQL Anywhere, ServiceNow (Berlin -Istanbul), SFTP,  Spotlight, SSH, SharePoint, SSAS , SSIS, SSRS, SAP Sybase 15.7,Vertex Tax, VMware, VirtualBox , VSphere, VB.net

COMPUTER CONSULTING GROUP - Columbia, SC                                                                           1994 - 1995

MS SQL Server and Visual Basic Developer

  • Commissions application support
  • Microsoft Access and Dbase applications upgrades to SQL Server
  • Visual Basic timekeeping application development

MILITARY SERVICE

Officer - 82nd Airborne Division, 99th Signal Battalion

  • Paratrooper Ranger Infantry Platoon Leader, Anti-Tank Platoon Commander - Saudi / Iraq, General Staff Officer