TECHNICAL SKILLS

Platform Support: Windows Server 2012 - 2016, Cent OS 7, SharePoint Server, Linux JBOD, UNIX, Ubuntu, Sun Solaris 9, VMWare ESX Servers, ERP, SAP, and Red Hat

Languages: VB.NET, T-SQL, HTML, XML, Java Script, IIS 6, Scripting, POLP, JSON, API, ERP, Agile Technologies P earl Script Monitoring, Remedy, SCCM, 2015 D, Service Now, Cognos, Azure SAAS, JIRA, Nimsoft

Application Support: TFS, Visio Studio 2016, Visual Source Safe, SSIS, SSRS, SSAS

Cloud Base Support: Virtual Box, AWS, Windows/SQL Azure, Cloudera Enterprise 4.0, VMware ESX, Box, Google Cloud Platform, and Azure SQL Data Warehouse

Database Support: High Availability-AlwaysOn, LiteSpeed, Idera, RedGate, PostgreSQL, Data Warehouse, Epic / Maria DB/Galera Cluster, AWK, and PERL, Epic Cache, SQL 2012, SQL 2017, Big Data, Hive, OODB, Oracle DB 11g/12c, RDS Portals, TOAD, and MySQL, Backup Exec, Net Oracle Apex, MongoDB

Dev Support: SQL BI, Query Tools, C#, .NET 4.6, Map Reduce, ASP.NET(MVC), EHR, T-SQL, Power Shell, Shell Scripting, & Micro Strategy

PROFESSIONAL EXPERIENCE

Senior Solutions Engineer/ Data Engineer

Confidential, Gilbert, AZ

Responsibilities:

• Provided database administration Supported for the current enterprise DMDC operating environments to include Oracle, Microsoft SQL, Sybase Adaptive Server Enterprise, NoSQL, Mongo, Hadoop, Exadata and MySQL platforms
• Developed technical specifications, Designed, develop, modify, test, and manage databases in DMDC’s multi-tier application architecture
• Recommend tools and practices to enhance performance and insights.
• Create documentation to supplement organization's knowledge, increase consistency, and facilitate ongoing management.
• Worked on PostgreSQL installations and monitoring of instances in production
• Assist and advise where necessary on all aspects of DBMS management, including regular maintenance activities, backups, and disaster recovery.
• Performed senior-level responsibilities for the overall database architecture, Designed, Installation, configuration, technical Supported, and maintenance of the MS SQL Enterprise databases in a Storage Area and Cluster Server environment
• Provided application development Supported for Query Optimization, Stored Procedures, Triggers, Indexes, etc. for multiple development applications
• Ensures accuracy and completeness of data backup and recovery and formulates and monitors policies, procedures, and standards related to database management
• Maintains error and system maintenance logs, administers replication and log shipping for large databases and issues reports on a regular basis
• Developed and tested storage strategies and disaster-recovery plan for large manufacturing company’s operational database, delivering solution that guaranteed recovery performance and high availability.
• Enhanced users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
• Collaborated with team leads to identify gaps and constraints associated with business requirements and process and aid in providing solutions to resolve the process issues
• Developed testing strategies and scenarios for review with both project and client teams to ensure alignment with project delivery documentation
• Logged and track defects and communicate to teams for resolution
• Worked within JIRA or other software development tools used by agile teams for tickets and project tracking
• Delivered high quality Worked and adapt to new challenges, as an individual or as part of a team
• Migrated (16) DoD applications from SQL 2008 to SQL 2012/14/16, also Worked with application teams to form some Supported standards from scratch.

Senior SQL Server and Oracle Data Engineer

Confidential, Luke AFB, AZ

Responsibilities:

• Used PowerShell and/or shell Script to develop, plan, and validate data for new or modified databases.
• Developed or Maintain State SSIS Packages with Migrations Supported and Production Supported
• Built several relational models for data access by incorporating tables with SQL DDL, and DML commands for a costumed Relational Databases. supported the Joint Strike Fighter (JSF) Autonomic Logistics Information System (ALIS) for Luke Air Force. OJT OCONUS assignment.
• Responsible for providing the overall on-site security auditing and Supported of the system.
• A s a part of the ALIS Security Administration team I utilized a series of automated auditing tools also augmented with manual processes to ensure that auditing occurs to guarantee compliancy of the accredited systems.
• We supported dev, and prod PostgreSQL servers, and monitoring of instances within production
• Monitored and reviewed security audit logs for software equipment
• Assist with hardware sanitization for equipment removal
• Maintained security documentation with updated as needed
• H andled and stored documents and media; enforce all United States Air Force (USAF) and local security procedures and practices.;

Senior SQL Server DBA

Confidential

Responsibilities:

• Lead in the migration, developing, and enforced database administration user standards and procedures; audits, modified, and amended data with SQL commands from a mainframe environment.
• Used PowerShell and/or shell Script to develop, plan, and validate data for new or modified databases to that we can have standardization and inventory of our servers.
• Developed or Maintain State SSIS Packages with Migrations Supported and Production Supported
• Built several relational models for data access by incorporating tables with SQL DDL, and DML commands for a costumed Relational Databases.
• Severed again as an subject matter expert for monitoring system performs and troubleshooting on a daily basis ETL (Extract, Transform, and Load) jobs to ensure data integrity utilizing FTP (File Transfer Protocol), Command Scripts, Task Scheduler, BCP (Bulk Copy Program) and DTS (Data Transformation Services) and SSIS packages
• Developed NAS/SAN enabled models for testing storage strategies, and disaster-recovery plan for large manufacturing company’s operational database, delivering solution that guaranteed recovery performance and high availability.
• We supported prod PostgreSQL servers, and monitoring of instances within production
• Enhanced users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
• Worked with programmers/analysts and /or data architects to review logical and physical data models. Ensuring that we are Code compliant with the State of Michigan’s data.
• Optimized performance with upgrades such as the migration from SQL server 2008/R2 SQL servers to SQL server 2012, successfully integrating new features and improved database stability.
• Worked on standardizing the redesigning, and new development processes across the entire State of Michigan Data Warehouse ETL/SSIS Frame Worked.
• Developed when needed ad-hoc Reports within SSRS
• Developed (12) custom financial and auditing reports using SAP Crystal Reports with T-SQL, JDE Report Design Aid, MS Excel and Access in conversion for the state of Michigan.
• Developed and reused ETL/SSIS scripts for loading or migrating
• Uplifted Migrated, and Administrated MongoDB, MySQL, and SQL Clustered 2016 Builds
• Ensured Data Security and maintain database security requirements for SOC1 & SOC2 Audit

Senior SQL Server DBA

Confidential

Responsibilities:

• Lead in the migration, Developed, and enforced database administration user standards and procedures; audits, modified, and amended data with SQL commands
• Created jobs using SSIS, ETL, T-SQL, PowerShell, Shell Scripting, for reporting and dynamic views of codes selected for System health
• Built several relational models for data access by incorporating tables with SQL DDL, and DML commands for a Costumed Relational Databases.
• Designed Databases, Tables and Assigned Object values
• Created or supported Microsoft Azure, Azure SAAS, and .NET C# networked connectivity projects
• SQL Production Supported with AWS Migration Supported to Cloud
• In-depth knowledge and experience with database replication between multiple SQL Servers and remote sites
• Worked with programmers/analysts and /or data architects to review logical and physical data models. Ensuring that Safeguard organizational data with a physical standby for disaster recovery and logical standby for reporting in addition to managing security using SQL logins, roles, and security protocols for various users.
• Uplifted Migrated, and Administrated MongoDB, and SQL Clustered 2014 Builds
• Optimize performance with upgrades such as the migration from SQL server 2008/R2 SQL servers to SQL server 2012, successfully integrating new features and improved database stability.

SQL Server DBA

Confidential

Responsibilities:

• Managed SQL DBAs in managing the team to perform migration Infrastructure task to Build Up from Oracle 8g to SQL 2008
• Created, developed, and maintained solutions using SSIS, specifically ETL operations within an Enterprise Level environment
• Managed the data integrity, security, availability, performance; facilitating necessary changes to improve overall system health checks.
• Modified some Databases with Database Sharing for quicker reporting.
• Ensure Data Security and maintain database security requirements for Datacenter Auditing
• Built-out Cloudera Hadoop with Data Virtualization for Tableau reporting
• Performance tuning ACT custom application for VCE using facts from performance counters.
• Installed new Test, Development, Prod RDMS instances on new VMware servers as needed.
• Assessed and incorporated user story analysis and elaboration to optimize software solutions.
• Worked on Agile development, Agile methodologies, SQL DBMS, HTML, Java, JavaScript, Linux scripting, object-oriented Programming, Oracle, Oracle databases, PL/SQL, relational databases, SQL, SQL Developer, UNIX, and XML.
• We supported dev, test, and prod PostgreSQL servers, and monitoring of instances within production
• Prepared project Worked times, and cost estimates for manager’s review, and approval, and oversaw Worked activities Assigned to junior DBAs.
• Installed and configured SQL Server 2012 and SQL Server 2016 with High Availability / AlwaysOn, Contained databases, or Column Store indexes by client requests.
• Granted users in database security roles and Created domain groups to put users into… also added user’s domain groups in Active Directory.
• Queried and analyzed large sets of data to draw conclusions and make recommendations to the business using statistical models and data mining techniques combined with business and operational knowledge.
• Conducted various analyses and providing thought leadership to identify new ideas that lead to improved efficiency and customer experience in our Inbound Contact Center. supported the business with process mapping, identification of process improvements opportunities for the purposes of generating cost-savings and improving customer satisfaction.
• Worked closely with Operations leaders, and Project Managers to further develop existing ideas, prioritize them, and implement them.
• Worked on Agile development, Agile methodologies, SQL DBMS, HTML, Java, JavaScript, Linux scripting, object oriented
• Participated in team meetings to plan for future scalable growth business needs from developers and vendors.
• Uplifted Migrated, and Administrated MySQL, and SQL Clustered 2016 Builds

Robert Half Technology

Confidential

Responsibilities:

• Client Services, Platform, and Services Layer Supported for Azure, and Software Supported of V-Cloud, and VMWare, Jira Tracking,
• Provided ideas for conceptual logical Designed for existing or new table changes for new databases/Instances.
• Built new virtual machines using VMware to test out new purposed code changes with application, business analysis, and sq. developers.
• EpicCare software I was tasked for setting up low volume databases for storage easing and reporting.
• Used (All Scripts) EHR to improve and edit new and current customer base. We were responsible for the VA updated records and reports
• Worked with System Administrator to update, add or change Application ID for groups supported by DBA team.
• Setup of Peer to Peer Replication to provide synchronous changes to secondary datacenters by the primary datacenter databases and by doing this it was a provided way of a D&R Strategy in case the primary data center goes down the secondary would provide primary Supported.
• Enhanced overnight migration Supported for Oracle 10g to SQL 2012 by using Antiunity drivers instead of ODBC drivers for Migrating Oracle 10i to SQL Server 2012 and SQL 2014. Production Supported went from 7 hours overnight to 2 hours overnight.
• Enhanced automation for reoccurring and redundant tasks i.e. backups, performance monitoring, and reporting for managers.
• Worked with various approved (IT)vendors, and software developers, and application developers with new promoted code changes for reports directed by management. supported ((4) SQL Productions Servers, (3) SQL Development Servers, (2) SQL Staging Servers, and a (1) SQL Report Server instances.
• We Implemented, and maintained the SQL 2012, and 2014 database Designed including physical and logical data models.
• Worked on and assessed and incorporated user analysis and guidelines to optimize software solutions and overnight processes.
• Also Worked on and assessed and incorporated user story analysis and elaboration to optimize software solutions.
• We Worked on Agile development, Agile methodologies, SQL DBMS, HTML, Java, JavaScript, Linux scripting, OOD and OOP with Oracle, Oracle databases, PL / SQL, relational databases, MongoDB, SQL, SQL Developer, UNIX