TECHNICAL SKILLS

• SQL Server 2008 R2, 2012, 2014, 2016, 2017, MySQL, MariaDB, SQL Lite, Netezza, Dremio and ProxySQL
• SQL Server Management Studio, Navicat, Aqua Data Studio Visual Cron, AutoSys, SQL Sentry and New Relic
• Oracle 11, PLSQL, Toad for Oracle, Oracle SQL Developer
• SQL Server Data Tools, Advanced ETL Processor, Astera Workflow, Talend Open Studio and Talend Service Bus
• AWS Relational Databases, Google Cloud SQL, Red Hat, vSphere Web Based Datastore Browser
• Google Cloud SQL, AWS Relational Databases, AWS Glue, AWS Step, AWS Database Replication and Spectral Core
• VB.NET, ADO.NET, ASP.NET, C#, Crystal Reports and SQL Reporting Services
• Visual Studio .NET 2010, Liquid XML and Stylus Studio
• Database and Query Performance Optimizing Techniques
• Relational Database Design, DataEdo ERD, Bulk Loading Strategies, Index Tuning and Relational OLAP
• Database Disaster Recovery and Business Continuity Planning
• Post - Relational Object Data Architecture
• Cache Multidimensional Object Database, CSP and Cache Web services
• HTML, ASP, JavaScript and VBScript

PROFESSIONAL EXPERIENCE

Confidential, Cranston, RI

SQL Server / MySQL Database Administrator

Responsibilities:

• Install SQL Server 2008 R2 and SQL Server 2012 on clustered platforms. Modified machine configurations in order to optimize available hardware resources. Built and deployed SQL Agent jobs used for index maintenance and updating data estimates / statistics.
• Set up alerting to the DBA group for various performance degrading events such as low space, blocking, deadlocks, low memory error conditions, failed backups and failed transaction log dumps.
• Captured slow running queries using a combination of Profiler and system DMVs. Analyzed query plans and implemented improved indexing strategies which reduced instances of slow client application response times.
• Implemented transactional replication software in order to synchronize SQL Server and MySQL data from the online databases in Chicago to a disaster recovery site located in California.
• Developed ETL and automated workflow processes using SQL Server Data Tools, Astera and Advanced ETL Processor to pull customer, order and order detail data and synchronize with target database platforms.
• Managed e-commerce web server and database platform infrastructure using vSphere. Implemented changes to the database tier in order to achieve better response times using a load balancer strategy.
• Implemented high availability, managed master / read slave as well as multi-master database topologies on cloud and bare metal platforms.
• Designed, coded and implemented ETL as well as streaming data processes from any number of data sources into a Netezza data warehouse.
• Reviewed and coded numerous SQL queries for Microstrategy using a Netezza data warehouse backend.
• Assisted in patching and upgrades to the Netezza database platform.
• Lead the effort re-coding Oracle stored procedures in order to attain better performance as well as scripts used to identify and purge historical data from the platform.
• Implemented nightly maintenance on MySQL, Postgres, SQL Server and Oracle platforms.

Confidential, Mansfield, MA

Oracle Database Programmer

Responsibilities:

• Build and maintain database ERDs which were used to plan updates needed for the company’s Federal Sunshine Act compliance.
• Coded PL/SQL batch scripts used to update Oracle 11 database schema objects. In addition data migration scripts were needed in order to load data into the updated table schema and pull data from existing schemas which were slated to be retired.
• Updated SSIS data flow mapping components in order to transform source data files from the old format into the new database structure.
• Assisted developers with coding stored procedures, views and triggers. In addition, analyzed and tuned SQL code using the query plan profiler in Oracle SQL Developer.

Confidential, Waltham, MA

SQL Server Database Programmer

Responsibilities:

• Designed and coded an automated routine for processing vendor files.
• Implemented workflow and SQL code updates in order to make better use of data processing exceptions and capture reasons as to why specific data elements could not be processed.
• Learned the workflow for the existing data matching framework and implemented SQL code updates in order to stop the system from duplicating certain data elements.
• Programmed a console application in C# which polled a SFTP site for vendor files. The utility copies the files to the local network and then interrogates the files to determine which processing rules should be used to import and process the data.

Confidential, Quincy, MA

SQL Server \ Oracle Database Programmer

Responsibilities:

• Designed and coded a user level security framework on an Oracle 11 platform used to interrogate employee processing permissions in the company's main application for servicing customer telecom requests.
• Coded PL/SQL Queries which aggregated product lines by customer and each carrier's products.
• Debugged and optimized aggregate queries using TSQL for a line \ data circuit verification system. This system gathers various attributes of the customer account and generates telecom circuit recommendations into a report format.
• Designed and coded reports using SSRS. These reports fulfilled various business needs such as when to end date circuits, aggregate circuit type counts by customer and track types of actions most performed on circuits.
• Built the SQL database for a Broadband application that is used for servicing broadband customers having T1, DSL and other types of fiber connectivity.
• Used performance metrics captured from runtime DMVs in order to tune various SQL Server configuration settings to achieve better performance from the hardware platform.
• Frequently worked with and assisted application programmers on achieving better query execution plans to resolve performance issues.

Confidential, Providence, RI

SQL Server Database Administrator

Responsibilities:

• Responsible for extracting data from a SQL Server 2008 datawarehouse which is loaded from a third party Customer Relationship Management system.
• Perform extensive analysis to map source CRM data to eight SQL database targets.
• Built SSIS packages utilizing Business Intelligence Development Studio 2008.
• Perform stored procedure TSQL coding in order to pass sets of data through business rule processing and stage the data through Views for extraction.
• Build reports utilizing SSRS to analyze ETL performance as well as provide a mechanism for viewing elements of data which did not pass business rule processing.
• The ETL framework consisted of a pattern which enabled all packages to log activity to a SQL backend as well as provide dynamic database connect string capabilities.

Confidential, Lincoln, RI

SQL Server Database Administrator

Responsibilities:

• Modified and optimized database maintenance strategies in order to fulfill custom restore requests.
• Built and maintained database server performance collection and reporting processes using a combination of built in metrics aggregation and reporting on that data using Reporting Services.
• Responsible for designing and coding TSQL queries, stored procedures, cursors and scripts.
• Collaborated with application developers and project managers on data modeling and various ETL tasks.
• Responsible for setting up replication and log shipping as well as disk space capacity planning and fulfilling requests for database security changes.