OBJECTIVE:

Seeking SQL Database Administrator position utilizing skills in data / database management, business intelligence, data architecture, and customer support across a mid to large - size Enterprise environment with the key objective of solving your simple or complex business requirements and performance challenges

SUMMARY:

• An accomplished IT professional with over twenty years of technical knowledge and skills utilized in the database development and production support of online transaction processing and enterprise business intelligence platforms across several business sectors.
• SQL Server Architecture & Administration SQL Server Installation, Configuration, & Patching
• Relational Database & Data Modeling Methodologies Backup / Recovery Software, Strategies, & Implementations
• ETL & Data Integration Technology (SSIS) End User Technical Support
• T - SQL Query Coding & Reporting (SSMS, SSRS) Performance Tuning & Optimization
• Comments from performance appraisals: logical, analytical, adept at problem solving.
• Strong communication, interpersonal skills. Multi-tasks well; can lead and/or follow; interfaces well across all levels of IT matrix and across operational business units. Highly motivated to learn new emerging technologies, increase technical depth, improve processes, develop and enforce standards, mentor other staff on data strategies and methodologies, and innovate ways to share and obtain knowledge.
• Successfully upgraded and migrated twenty-three applications and two hundred fifty-eight databases from SQL Server 2005 to SQL Server 2008R2 and from one domain to another. This upgrade project resulted in over $100,000 in SQL Server license savings due to decommissioning of eighty-five databases.
• Utilized BI data tools (SSIS, SSRS) to design, develop, and deliver an automated SQL Server Inventory System which simplified/enhanced Microsoft true-up analysis, SQL Server upgrades, and merger/divestiture data migrations by reducing planning and analysis time by 80% at CB&I.

COMPETENCIES:

RDBMS: SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, MS-Access, MySQL 5.5, DB2, Oracle 11gR2

Performance: IDERA Diagnostic Manager, SQL Server Profiler, Activity Monitor, SQL DMVs

Languages/ BI Tools: T-SQL, Visual Studio 2012, SSMS, SSDT, SSRS, SSIS, Tableau, Windows Power Shell, Visio 2016, Erwin Data Modeler

Desktop Applications: Microsoft Office Professional 2016 (Word, Excel, Access), Microsoft Outlook, Lotus Notes

OS/VM Software: Windows 2008/2012 Server; VMware Player 5.0, UNIX.

Network Topologies: TCP/IP, DNS, FTP

PROFESSIONAL EXPERIENCE:

Confidential, The Woodlands, Texas

SQL Server DBA/BI Developer

Responsibilities:

• Installing, configuring, patching, and supporting SQL Server (2005, 2008, 2008R2, 2012, 2014, 2016) on Windows platforms.
• Supporting approximately twenty-one hundred databases, along with one other SQL DBA in India, across more than one hundred fifty SQL Servers in development, acceptance testing, and production environments.
• Troubleshooting issues across various tiers (application, database, network, storage, server) and managing disk space.
• Experience with Windows PowerShell, Registered Servers and CMS groups for more effective query analysis and data management.
• Setting up full, differential, log backups and performing database recovery as needed.
• Creating and maintaining monthly archival and retrieval scripts using SQL Agent and Tivoli Storage Manager.
• Reorganizing and rebuilding indexes and checking database integrity for development, acceptance testing, and production environments.
• Utilizing SolarWinds Network Performance Monitor, IDERA Diagnostic Manager, SQL Activity Monitor, and SQL Dynamic Management Views for database tuning and performance monitoring.
• Supporting high availability implementations of SQL clustering, failover, and transactional replication with limited experience in Always-On Availability Groups.
• Implementing user login accounts and security levels and privileges for the purpose of safeguarding data within SQL Server and within SSRS.
• Utilizing remote desktop logins, Windows Server, physical and virtual machines, SAN storage components, and CIFS.
• Expertise working across multiple domains and dealing with the complexities that arise as a result of accessing data across domains.
• Reviewing and implementing database changes provided by developers and vendors prior to deploying to production.
• Designing and implementing automated software tools to facilitate DBA / application processes through use of SSIS packages, SQL ETL, and SSRS Reports, including utilization of Visual Studio.
• Developing documentation for database administrative standards, processes, policies and database diagrams.
• Fulfilling incidents and requests daily to ensure service related issues are properly identified, troubleshot, and resolved.
• Supporting applications that utilize SQL Native Client in multi-tier server environments and Web Services APIs.
• Expertise in coding and validating SQL scripts and creating stored procedures, functions, tables, views, triggers, indexes, and constraints.
• Experience leading technical teams for data migrations, SQL upgrades, and Disaster Recovery DBA Projects which involves communication and collaboration with a broad spectrum of business and IT personnel.
• Training new SQL DBAs in all aspects of production and development support.
• Ensures performance, reliability, availability, capacity, and recoverability of data.
• Participating in on call rotation as a means of providing twenty-four hour SQL Server database support.
• Attending professional SQL Server onsite or online classes annually.

SQL BI Developer

Confidential

Responsibilities:

• Working with IT project teams and business clients to collect, clarify, and translate business requirements into documentation and conceptual design that yields BI solutions.
• Experience in BI development creating / debugging / deploying SSIS dts packages, defining new data sources in ODBC, utilization of Visual Studio and Business Intelligence Development Studio.
• Experience downloading data via ETL (SSIS dts packages) from JD Edwards Enterprise One (DB2 application) and Peoplesoft (Oracle Application) into various SQL Server web-based applications.
• Defining and documenting business requirements and then creating, deploying, and migrating SSRS reports.
• Performs ongoing monitoring and refinements to SSRS reports and SSIS packages.
• Critically analyzes data through SQL query scripting to devise the best course of action for data cleansing, proposes solutions to end users and executes optimum solutions.
• Knowledge of the Kimball data warehouse lifecycle and star schemas including experience in extraction, transformation, and load processes from operational systems into BI databases.
• Provides end-user training and assistance with SSRS reports and their utilization of Report Builder as an end user design tool.
• Troubleshooting and proposing solutions to poorly performing Cognos / Business Object reports.
• Processing Service Desk Tickets and Incidents ensuring all problem management issues are resolved in a timely manner.

Confidential, Conroe, Texas

SQL Database Administrator/BI Developer

Responsibilities:

• Supporting all financial, operational, and Business Intelligence projects and solutions.
• Designing new database / data solutions using Microsoft SQL Server, Excel (pivot tables), and Microsoft Access.
• Mentoring the accounting team in the effective utilization of Microsoft GP ERP and third-party products (Encore, eOne SmartConnect, eRequester, Mekorma MICR, Zevez) by providing data integrity, data security, and data integration.
• Interfacing with vendors for troubleshooting, defect resolution, and software installations and upgrades.
• Mentoring end users in identification of data sources and SQL Server ODBC connectivity solutions.
• Interfacing directly with engineers to improve data accessibility, data accuracy, and to provide problem solving.
• Writing SQL code and designing tables that support the enterprise data model (tables, views, indexes, constraints, and reports).
• Improving data performance by monitoring index fragmentation, rebuilding indexes, and modifying SQL code.

BI Developer

Confidential

Responsibilities:

• Migrating data across environments and data integrations of disparate systems.
• Writing complex SQL reports using Common Table Expressions and outer joins.
• Creating customized reports by accessing data in Excel, Access, and SQL Server using Crystal Reports.
• Creating just in time inventory reports against Microsoft GP using Microsoft SQL data.
• Creating Excel spreadsheets using Dynamics GP data stored in Microsoft SQL Server using Jet software and ODBC.
• Developing strong knowledge of conceptual and physical data models of Microsoft GP ERP.
• Experience with data visualization software including Tableau Desktop and Tableau Server.

Confidential, Spring, Texas

Database Manager

Responsibilities:

• Maintaining all company databases and information systems.
• Filter, purge, and clean-up data and review reports in order to correct data integrity issues and code problems.
• Designing and producing monthly reports and web forms for web-based software.
• Leading support staff in data management of all data stored in Microsoft SQL Server.
• Providing end-user training of web-based software.
• Identifying software bugs and interfacing with software vendor for effective problem resolution.
• Work closely with management to prioritize data and information needs.

Confidential, The Woodlands, Texas

Database Technical Consultant

Responsibilities:

• Installing new releases of Microsoft SQL Server 2008 for clients including SSRS, SSIS, and SSAS.
• Converting Oracle SQL reports to SQL Server.
• Training new clients in SQL query coding and reporting.
• Implementing ETL interfaces to support conversion of accounting data to an enterprise ERP.
• Implementing business intelligence solutions for accessibility of Microsoft SQL data across disparate platforms including Microsoft Access and Excel.
• Attended Fundamentals of ArcGIS for Petroleum and the Editing in ArcMap classes through TeachMeGIS.

Confidential, Colorado Springs, Colorado

Staff Accountant

Responsibilities:

• Periodic maintenance of journal entries.
• Supporting the month end, quarter end, and year end closing processes.
• Intercompany billings, transactions, and reconciliations.
• Preparing journal entries and account reconciliations for cash, prepaid expenses, and payroll.
• Generating client invoices for onsite / offsite consulting and training.
• Performing LIFO / FIFO stock valuation on valuation of portfolio funds.
• Designing and generating financial investment charts, graphs, and reports using Microsoft Excel.
• Analyzing data for planning of future stock investments.
• Reporting present and future financial investments to executive team.
• Interfacing with brokerage companies for purchase and sales of stocks.

Confidential, Seattle, Washington

Database Administrator / Oracle

Responsibilities:

• Database development designing, implementing, and tuning Oracle databases / tables / views / indexes for transactional platforms.
• Leverage data modeling tool and code repository to maintain database designs and code deployments.
• Tuning databases, supporting database release cycles from Development, QA, and UAT to production databases.
• Verifying all scheduled jobs have completed successfully.
• Refreshing test environments from production databases.
• Backup and recovery operations using RMAN, export/import and database cloning.
• Administering database user and role security in addition to file system security.
• Mentoring application developers in data access and manipulation of Oracle tables.
• Troubleshooting production abends and inspects error logs for unusual events.
• Interfacing with application development, system administrators, and vendors to resolve maintenance issues.
• Maintaining database documentation and standards.
• Designing, implementing, and tuning DB2 databases / tables / views / indexes for bill of materials project.
• Forward and reverse engineering databases / tables / views / indexes utilizing erwin Data Modeler.
• Training DBAs in database design and operational issues related to new / existing applications.
• Supporting existing inventory management applications in nightly, on call issues relating to missing objects, out of space conditions, data conversion issues, disk errors, backup and recovery of databases, etc.
• Mentoring application developers with database access / manipulation throughout Software Development Life Cycle.
• Created processes, procedures, and best practices for database administration and trained new DBAs to follow them.
• Upgrading to new releases and installing upgrades to DB2 and third-party software products.
• Executing patches / data fixes.
• Executing index reorgs and runstats on databases to improve overall optimization of data retrieval.
• Maintain database security and disaster recovery procedures.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Oversee utilization of data and log files.
• Manage database logins and permissions for users.

Senior Application Programmer

Confidential

Responsibilities:

• Developing the data flow diagrams and business functional specifications for a new digital airplane maintenance system.
• Leading a team of application developers in the coding of the new digital airplane maintenance system.
• Providing nightly on-call production support and effective problem resolution to payroll / personnel applications written in PL/1.
• Coding new salary history reports using PL/1 programming language.
• Adhering to the System Development Life Cycle process, ensuring others follow process, and produce the SDLC deliverables for QA reviews.
• Work with users daily by phone, e-mail and help desk to troubleshoot and resolve operational problems.
• Collaborate with team members from all areas of the business.