OBJECTIVE:

To obtain a challenging position utilizing management skills.

SUMMARY:

• Experienced in IT management, database architecture, design and administration, data modeling, and installation/configuration of SQL Server.
• Self starter, studied MCDBA material and built on IT background to gain DBA experience and certification
• Experience managing projects, working independently, and also as part of a close knit team
• Recognized for strong work ethic, creative thinking, and excellent customer service.
• Highly effective written and verbal communicator with diverse employee pool.

EXPERIENCE:

Confidential

Data Architect / Development Manager

Responsibilities:

• Lone DBA for mid - size manufacturing and growing e-commerce company
• Development manager, supporting roughly 50 custom applications across a variety of platforms, including C#, internal web tools, extranet and Access.
• Led migration from inherited production applications out of Access to modern C# and web service models.
• Led migration from dependence on ABAP resources for SAP extracts to direct write from SAP to Repository.
• Gathered requirements from users to convert to deliverables and milestones for developers.
• Led triage and UAT for projects to resolve bugs and deploy feature requests with minimal downtime.
• Led initiative to move project management to online tools to better assign and manage project priorities of the team.
• Led source control and documentation initiative for better cross training and support with limited cross department resources.
• Overhauled recruiting process to better identify and hire qualified candidates.
• Primary escalation point of operations support for all database servers, including direct to consumer e-commerce websites responsible for 30% of all company revenue.
• Increased efficiency, stability and performance in OLAP and nightly reporting process feeding SAP Repository by over 50%.
• Led the migration of database infrastructure from SQL 2000 to SQL 2005/2008 to SQL 2012 HA
• Supported replication for the e-commerce site.
• Built data feeds to partners to maintain inventory control.
• Extensive ad-hoc reporting
• Enforced security practices company-wide to maintain Sarbanes-Oxley compliance.

Confidential

Senior Database Administrator

Responsibilities:

• Lead DBA for IT operations support of Search databases (dogpile, metacrawler etc.). Backup DBA for IT operations support of Directory databases ( Confidential, switchboard etc.).
• 24/7 support for high transaction OLTP environments of several hundred gigabyte databases.
• Work with engineering groups to steer code and deployment optimizations minimizing downtime and support issues. Help coordinate engineering efforts with data warehouse efforts to effectively streamline front-end inputs with back-end OLAP reporting.
• Work with system and network engineering to proactively manage database growth, SAN-configuration, backup strategies and to resolve connectivity, load balancing and firewall issues as needed.
• Manage, build and coordinate large daily transfers of data across the country (Seattle to Boston) for system support.
• Proactively create alerting strategy to alert production operations to errors during off-hours so that they can escalate to the DBA group for top-tier support.
• Steer purchasing decisions based on anticipated hardware needs.
• Enforce security practices across engineering, QA, and data warehouse to maintain Sarbanes-Oxley compliance.
• Document processes to enable cross-training and streamline coverage efforts across the team.

Confidential

Data Management Lead

Responsibilities:

• Lead and founding DBA of the Data Management department.
• Lead interview, hiring process, performance evaluation, and training for Data Management personnel. Assign and manage priority for all incoming work requests and projects.
• Work with senior management to help mold and shape business requests into functional requirements and scheduled deliverables related to data infrastructure.
• Data Architect for the fulfillment database. Responsible for planning, managing, and implementing deployments and change requests for the database.
• Built and maintained data warehouse of Confidential product activation data for reporting back to Confidential marketing managers.
• Rebuilt indexes and instituted maintenance procedures to increase database performance.
• Implemented best practices for documentation and use of stored procedures and triggers.
• Built and supported replication to the reporting database.
• Experience supporting data feeds to other dependent systems.
• Experience troubleshooting SQL Mail issues.
• Designed client applications to manipulate back-end data in SQL Server. Updated performance and maintained compatibility of client applications with SQL Server.
• Extensive data conversion to manage uploads from a variety of client sources.
• Extensive ad-hoc reporting
• Managed all SQL Server security.
• Designed and implemented a log-shipping failover strategy.

Confidential

Tier 3 Operations Support Analyst

Responsibilities:

• Last line of 24x7 support for the Confidential, the core application for PSS. Clarify is an OLTP application for tracking all Confidential customer support with a SQL Server 2000 back end. It supports an average of 3000 concurrent users and is expected to demonstrate 99.999% uptime.
• Provide round the clock operations support for all application servers.
• Part of a duty pager rotation. Design of the team is to have the on duty analyst drive all issues that arise on shift from start to resolution.
• Coordination with international support teams in Asia and Europe for deployment of application enhancements/upgrades. Operations is the guardian of the system and must proactively resolve Production issues that arise as a result of change before deployment.
• Experience supporting replication, clustering, log shipping, failover and redundancy.
• Ad hoc data analysis and maintenance of the Clarify database.
• Performed SAN administration and support.
• Performed Terminal Server support for numerous outsourcers.
• Experience troubleshooting LAN/WAN connectivity issues. Americas Clarify Operations also owns dependent applications that are replicated globally.
• Experience troubleshooting ISA Proxy server connectivity issues.
• Experience supporting data feeds to other dependent systems.
• Frequent TCP/IP troubleshooting required as servers are required to communicate with each other globally.
• Thorough understanding of Active Directory and NT administration required to administer tens of servers between Production, Pre-Production and test environments.
• Experience troubleshooting Exchange issues as Clarify requires dedicated Exchange accounts.
• Experience in a fast, ever-changing, ambiguous, busy environment.
• Multi-tasking and prioritizing issues are critical to success.
• Excellent communication skills required between several related support teams.

Confidential

Database Administrator

Responsibilities:

• Database Architect for all of Confidential databases. Helped centralize, link and clean up various company data stores across departments.
• Integrated a myriad of Access databases with overlapping data into SQL Server, introduced the first data integrity rules and built enforcement of these rules into client applications.
• Designed client applications to migrate data across SQL Server databases. Updated and maintained compatibility of client applications with SQL Server.
• Project Manager for upgrade to new SQL Server based accounting system from a COBOL system. Organized company resources and coordinated members of different departments to meet deadlines for the transition.
• Performed data conversion for the upgrade from a COBOL based system to a SQL Server based accounting system
• Extensive use of macros and VB modules to streamline data conversion.
• Built custom reports for the accounting system
• Provided round the clock operation support for database servers.
• Managed all SQL Server security.
• Designed and implemented a backup strategy.
• Authored Confidential Data Dictionary.
• Diverse background assisting in support of all IT infrastructure across the organization. The Confidential IT team is a small team supporting several offices dispersed geographically across 5 states.
• Primary consultant to establish the Confidential helpdesk. Also, helped formulate much of Confidential policy and procedures on running the helpdesk.
• Authored material on IT policy for Confidential, most notably policy for electronic document management
• Performed software evaluations to determine suitability for company purchase and implementation (SQL Server, Exchange, Content Management Server)

Confidential

IS Operations Intern

Responsibilities:

• Database Administration
• Built an inventory database for the helpdesk
• Technical writing
• Initiated proactive approach to workstation support