| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Candidate's Name
4904 Skymeadow DrFort Worth TX 76135PHONE NUMBER AVAILABLEEMAIL AVAILABLEObjective:To obtain a challenging position that allows me to utilize my skills as a Database Developer.Highlights:Supported and designed databases ranging over 250 terabytes in size.Supported databases having over 120 million users.Wrote articles for sqlcommunity.comAssistant Host for SQL Fest a Microsoft community conference for database professionals.Designed distributed systems for world-wide websites.Build sql server cluster systems using window 2012 and sql server 2012Designed sql server stretch cluster for sql server 2012Knowledge of PPDM Oil and gas data modelingWorking on the Adventure Works Data warehouse.Rewrote two mdx queries for performance from running in 4 hours down two 3 seconds.Speeding up partition building for cubes by utilizing partitions.Work Experience:Senior Database DBA/DevleoperJune 2016 -PresentBNSF Forth Worth - TxSupport Positive Train Control System (PTC) which enables remote control of a locomotive in case of emergenciesReduced blocking/deadlocking from around 300 a day to 2.Monitored server activity using perfmon and Idera SQL manager to make recommendations for drive layout and hardware.Wrote multithreading tool for bulk copying tables from one server to another. Reduced time from 4 hours down to 1 hr 30 min.Rewrote queries for performanceMentored developers on writing queries for performance.Reviewed databases for design/performance enhancements.Redesigned PTC database/data marts for performance.Built environments for qa and development.Build replicated environments for performance and disaster recoveryPerform upgrades and install service packs.Meet with sys admin team to review hardware refreshes.Write stored procedures for PTC, NMS systemWrite clr Functions for PTC system for algorythms.Developed database in MongoDb for storing XML documents.Wrote queries for Teradata for reporting system.Senior Database DBA/ArchitectMarch 2016 June 2016PVI Industries Fort Worth TxBuilt SQL Cluster for production databaseWrote and modified SSRS ReportsBuild SQL server clusters using sql server 2012 and windows 2012Supported Epicore ERP systemBuilt Reporting server for reports using SSRSWrote/modified queries for performanceSenior Database DBANov 2015-March 2016Aperia Solutions - Dallas TxAutomated Table Partitioning for large tables.Mentored Junior DBAsTaught performance tuning for developersBuilt SQL Clusters for production databases.Reviewed and Optimized sql code and SSIS packages.Wrote and modified SSRS ReportsPerform upgrades and install service packs.Built environments for qa and developmentPerform backups and restores using com vault for disaster recovery and test environments.Monitored performance using Idera diagnostic managerReviewed database design for data marts/data warehouse to optimize performance.Created design for the first data warehouse for client reporting.Wrote SSIS packages for uploading client data.Wrote stored procedures for uploading/transforming client data.Senior Database DBA/DeveloperJuly 2015 Nov 2015Ambit Energy Dallas TxOptimize/tune queriesParticipate in development/database design meetingsWrote multi-threaded sql command tool to run commands in parallel in c#Worked with hadr using availability groups for performance and disaster recovery.Support 2012 and 2014 databasesUpgrade sql versions from 2008 to 2014.Participated in disaster recovery testing.Provided feedback to development staff for query optimization and indexing.Supported/Designed Cassandra and MySql databases for data warehousing project.Wrote stored procedures for billing application.Senior Database DeveloperMarch 2015-July 2015Rigdata Corp Fort Worth TxDevelop Data warehouse model for oil rig data using Erwin in oracle.Wrote SSIS and c# clr stored procedures for uploading data from various sources.Wrote ftp clr c# stored procedure.Wrote excel file upload in c# using linq to scrub and upload spreadsheets.Wrote access bulk program to automatically map datatype and fields.Wrote data scrubbing routines to check data types to verify correct types and sizes.Wrote and modified SSIS packages to collect data from different systems to consolidate data.Helped design reports in SSRS to display data (oil rig data).Wrote data driven table system thats builds table mappings from excel spreadsheet, that then buildsthe merge statement for the upload in a c# clr, using linq.Managed Oracle 11g database for datawarehouse.Database DeveloperJuly 2013-March 2015Healthcare Payment Specialists Fort Worth TxDesign and develop and support database systems for clients.Wrote matching algorithm in c# function to match similar account numbers. Process time when from average of 4 hrs to 10 minutes.Designed and redesigned database schemas including logical and physical designs.Designed and implemented disaster recovery, including writing a procedure to determine (based on size) if a full or incremental backup should be performed.Wrote routine to delete old backup files.Designed data warehouse using data marts from various systems using SSAS.Trained staff on query optimization and how to read query plans.Wrote index function to rebuild those indexes that had new page allocations.Wrote c# multi-threaded tool to parallelize query commands.Wrote service broker application for processing long running queries.Wrote program to calculate performing full vs. differential backup.Wrote c# tool for deleting old backups using plinq.Wrote mdx queries for dimensional analysis, include designing reports in SSRS.Supported sql 2008, 2012 and 2014 databases.Applied service packs and code releases.Used Team Foundation Server for code source controlUsed Redgate tools for doing releases and scrubbing data for test envoronmentsWrote stored procedures for StringRay system.Sr. Database DBANov 2011 July 2013Gartner Trumbull CtSupport databases for internal/external clients.Monitor/tune both SQL server and analysis services databases and servers.Setup and support transactional replication with updatable subscribers.Build SQL server clusters using sql server 2012 and windows 2012.Wrote and analyzed mdx queries.Designed and deployed partition builds for SSAS.Ran aggregation tools to estimate which aggregations to build.Wrote ETL process for uploading data into the data warehouse.Assisted in building cubes based on usage.Build log shipping and mirroring databases.Senior Database DeveloperJan 2010 Nov 2011Conning and Co. Hartford, CTSupport and design databases for financial reporting systems.Administered databases including adding users, backups, capacity planning etc.Wrote TSQL queries for reports.Tune queries for performance using query analyzer.Designed reporting system/data mart using replication and log shipping.Mentored other DBAs.Wrote tools for replication setup and monitoring using c# and SQL rmo.Wrote multi-threaded file copy program using c#.Designed and built database for new reporting systems.Wrote index rebuilding program that is multi-threaded and self optimizing.Wrote reports using crystal reports.Used table partitioning for disk optimization.Database EngineerJan 2009 - Jan 2010Oakleaf Waste Management Hartford, CTSupported and designed databases for company.Wrote T-SQL queries/stored procedures for acorn system.Wrote SSIS packages for data loading.Designed databases for reporting and data warehousing.Wrote MDX queries for SSAS.Setup up replication and log shipping.Administered databases including adding users, backups, capacity planning etc.Created reports using SSRS.Tuned queries and built indexes for performanceBuilt SQL server clusters including setup and installation.Database EngineerOct 2008 Jan 2009Microsoft Corp. Redmond WaArchitected systems for MSN Ad centerDesigned replication mirroring and log shipping for reporting systems.Supported 250+ terabyte database systems.Tuned queries using query analyzer.Built and designed indexes for performance.Mentored junior level DBAs.Administered databases including adding users, backups, capacity planning etcMet with developers for planning design and direction of database systems.A Lead DBA for ad center team.Database DeveloperMar 2008 - Oct 2008Lending Tree Charlotte, NCDeveloper for SQL server and c# database utilitiesWrote stored procedures for mortgage, real-estate systems.Modeled/ reviewed database design.Wrote c-sharp applications for auto-generating stored procedures.Wrote c-sharp fuzzy login algorithms for doing matching queries.Mentored other developers.Wrote SSIS data load packages.Wrote reports using SSRS.Tuned queries and created indexes for performance.Database EngineerMar 2007 - Mar 2008Microsoft Redmond, WASupported MSN websites including MSN Money and Autos.Monitored databases systems, including performance tuning, analyzing indexes.Built and supported replication and log shipping and mirroring systems for reporting systems.Write SQL tips for newsletter for query writing, creating clr apps etc.A leader of SQL Fest a bi-monthly conference for covering topics with SQL for Microsoft community.Wrote C# database performance counter for measuring/recording database size.Wrote C# performance counter for calculating disk usage taking into account RAID.Wrote C# utility for multi-threaded compression disk copy.Built SQL Server clusters including setup and installation.Administered databases including adding users, backups, capacity planning etcDatabase ArchitectNov 2005 Mar 2007SunTrust Bank - Richmond, VASupport SQL Server database design, performance tuning and maintenance for consumer loans dept.Wrote TSQL queries and stored procedures for department.Assisted in writing compression/backup software to backup databases using c++ and SQL VDI.Wrote WMI Query performance tool in visual c++ to query performance counters as an extended stored proc.Worked with server/network operations in designing hardware for performance/capacity planning as well as clustering.Administered databases including adding users, backups, capacity planning etc.Planned and budgeted for new database systems.Designed/modeled databases for mortgage areaDatabase ArchitectFeb 2005 Nov 2005USI Annapolis, MDSupported and administered SQL Server and Oracle Databases.Supported SQL Server clustering, replication log shipping and Oracle RAC.Tuned queries and stored procs for performance.Supported Oracle backups/performance tuningWrote scripts in perl, vbscript for monitoring.Worked with server/hardware depts for capacity/performance planning.Supported databases in a 7x24 environment.Supported Peoplesoft and Seibel databases including upgrade installs etc.Administered databases including adding users, backups, capacity planning etc.Software DeveloperNov 2003 Feb 2005Beta Systems Brookfield, WIWrote stored procedures in SQL Server.Coded in Visual Basic/MTS for middle layer of software.Supported client databases including tuning backups, restores, capacity/hardware planning.Designed mainframe upload software using visual c++, visual basic, SQL server.Wrote a capacity/performance tool using visual basic/winsock to test data retrieval/inserting using various hardware/raid levels.Built SQL server clusters.Designed database for client data entry calendar system.DBANov 2002 Nov 2003US Bank Brookfield, WITeam leader for SQL Server database systems.Supported SQL Server, Oracle, Informix databases on Windows and Unix platforms 7x24Built SQL Server clusters using active/active configuration.Wrote email software to send messages from servers when jobs fail.Wrote performance scripts for both Windows and UNIX platforms.Tested clustering software including Veritas and Leagto disk mirroring.Designed databases and Data marts for reporting for various depts.Built and supported hardware for online user interactionSystem Design/ArchitectJun 1997 Oct 2002Contractor - Milwaukee, WIDatabase/Application design and programming.Designed and coded software for Oracle and SQL Server packages.Wrote code for various applications in Visual Basic Visual C++, Delphi, and Foxpro including billing/payables system, configuration tool for pipe fittings, and patient care system for cancer patients.Supported both SQL Server and Oracle database systems.Designed databases for billing and payables systems.Designed and built data warehouses using SQL Server and Oracle ranging from 20 gigs to 1.2 terabytes.Built clusters using SQL Server.Designed systems using replication and log shipping using SQL Server and Oracle.Supported Peoplesoft HR and payroll systems.Programmer/Data AnalystDec 1994 Jun 1997BankOne - Waukesha, WI-Designed/implemented novell Network for a fifty person dept.-Wrote programs using Foxpro/C and Sysbase/SQL Server for employee benefits and mortgage dept.-Designed data marts for departmental reporting using Sybase/SQL Server.-Designed etl/parsing tool using C for data extractions.Programmer/AnalystDec 1992 Dec 1994Northeastern University Boston, MAWrote and supported applicant tracking software for graduate admissions dept in DbaseWrote statistical analysis programs using fortran for data analysis for research projects conducted by staff.Supported 30 user novell networks including setting up workstations, adding users etc.Designed database for student application process.Support AnalystAug 1990 Dec 1992Lotus Corp Boston, MATechnical support for Lotus 123 and symphony(database package) for customersAssisted in the development of databases for customers.Wrote custom functions in c++ for customers.Wrote macros for customers.Trained group on novell networks for supported Lotus products on a networkEducationJan 1990 Jun 1993Northeastern University Boston MAM. Ed Educational ResearchAug 1982-Dec 1986Emerson College Boston MAB.S. Comm Science. |
