We provide IT Staff Augmentation Services!

Data Architect\database Administration Manager Resume

2.00/5 (Submit Your Rating)

Lake Forest, IllinoiS

SUMMARY

  • Highly dedicated Data Architect\Database Administration Manager with over 12 years of experience in data architect, database infrastructure design and implementation, database and middleware administration, solution architectures, web development and administration
  • Specialized knowledge and expertise on data modeling, enterprise data warehouse design and implementation, ETL process, Master Data Management, Data Quality and Data Governance
  • Strong in OLTP\OLAP database design, development, performance optimization, operation and production support, and database infrastructure system design and build
  • Adept at maintaining overall health of large and complex different RDBMS database like SQL Server 2000, 2005, 2008, 2012 and Oracle 9i, 10g, 11g, Exadata, clustered and non - clustered databases on all platforms
  • Hands-on experience in architecture, data integration and analysis using Big Data Stack like Hadoop, MapReduce, Sqoop, Pig, Hive, Impala and HBase.
  • Broad work experience and technical knowledge on middleware support and administration, web development and administration, infrastructure build and maintenance, application support and project management
  • Demonstrated excellent leadership skill managing 3 teams and total 10 direct reports consists with Database Administrators, Middleware Administrators, Solution Architects, Web Developers and Web Administrators onsite and offshore
  • Proven record of success in resource management, budget planning and cost reduction estimation and have saved approximately $700,000 for Confidential with creative and efficient solutions on database monitoring and database system consolidation
  • Highly dedicated and built a reputation of 100% delivery of all business critical and infrastructure projects on time and within budget as well as providing flawless production operational support with excellent organization and planning skills
  • Solid knowledge and experience to integrate, manage and promote physical data models and data model standards that source data from multiple origins
  • Extensive experience in database installation, upgrade, management, support and migration in 24x7 high-availability production database systems with high-volume of transactions in a fast-paced environment
  • Great communication and interpersonal skills and ability to work directly with business/applications users and all levels of staff and management.
  • Strong ability to cultivated professional relationships with vendors, clients, business, IT personnel, and various departmental staff.
  • Self-motivated and demonstrated the ability to work with minimum directions, meet aggressive deadlines and juggle multiple and changing priorities.

TECHNICAL SKILLS

Database: MS SQL Server 2000, 2005, 2008, 2008 R2, 2012 stand-alone and clustered instances, OLTP & OLAP maintain and support, VLDB, High Availability, Alwayson, Replication, Log Shipping, Database Mirroring, Backup and Disaster Recovery, Data Warehousing, MS SQL native and LiteSpeed Backup/Restore, SQL Server Integration Services(SSIS), DTS, ETL, Reporting Services(SSRS), Analysis services(SSAS), Notification Services(SSNS), T-SQL, Stored Procedures, triggers, Data Modeling Design, Database Performance Tuning, SQL Performance Dashboard, SQL Profiler, PerfMon, Idera Diagnostic/Compliance Manager, Embarcadero Performance Center, Symentec I3, Red Gate SQL Compare, SQL Multi Script.Oracle 8i, 9i, 10g, 11g, RAC, Exadata, SQL *Plus, PL/SQL, *Net, Net8, SQL *Loader, Import/Export, RMAN, AWR, FailSafe, OEM, Grid Control, Sybase, Cache, Big Data.

Big Data: Hadoop, MapReduce, Sqoop, Pig, Hive, Impala, HBase, Hue.

OS\Software: Windows Server 2003, 2008, 2008 R2, UNIX AIX, Solaris, RedHat Linux, SAN, VMware, RAID, SharePoint, Visio SCOM, Tivoli Storage Manager, EMC Avamar, PeopleSoft Financial/HR, BizTalk, Toad, Putty, CVS, Crystal Report, ServiceNow, Remedy, Exalogic, Tomcat, WebLogic, Exalogic, Symentec NetBackup, CRM, SAP, ER/Studio, ErWin.

Languages: ASP.Net, C#.Net, VB.Net, C/C++, Visual Basic, Java, Perl, JavaScript, CSS, ASP, HTML, XML, XSLT.

PROFESSIONAL EXPERIENCE

Data Architect\Database Administration Manager

Confidential, Lake Forest, Illinois

Responsibilities:

  • Developed strategies and provided architectural solutions for miscellaneous large Enterprise Information Management projects like Enterprise Data Warehousing Build, Enterprise Data Archiving, Master Data Management implementation, etc.; designed and built staging and data warehouse databases; optimized BI ETL processes, designed and implemented SSIS Packages to automate data collection and loading for tracking Confidential finished goods inventory and significantly reduced the data loading activity from 24-48 hours to few minutes.
  • Developed and maintained logical and physical data models from functional specifications, data requirements, and business rules provided by clients; designed and implemented multiple phases of data warehouse with data extracted from various OLTP systems like contract, rebate, medical device tracking and management systems, etc., transformed and loaded for a centralized pool of data to report from.
  • Designed and built various OLTP\OLAP databases ensuring high availability, scalability, performance and security like Business Object Data Service Tool, Sales Forces staging databases involved in pharmaceutical drug global distribution; architected framework to provide data mart solutions on HR, complains, finance, and risk analysis; designed data marts and cubes for all reporting efforts.
  • Performed architecture design for Hadoop based data warehouse for unstructured customer and product data; performed data integration and analysis using Sqoop, Pig, Hive, Impala and HBase; defined strategic architectural design for large infrastructure projects like Data Center Migration, Application and Infrastructure Service Provider Transition, IT Service Management Tool Transition(from Remedy to ServiceNow), etc..
  • Manage 4 teams and total 12 direct reports consists with Database Administrators, Middleware Administrators, Solution Architects, Web Developers and Web Administrators onsite and offshore, managed resource demand and capacity and successfully achieved 100% delivery of all business critical and infrastructure projects on time and within budget every year while driving operational excellence with flawless production support.
  • Trued up the licensing for approximately 4,200 Oracle and SQL Server database; consolidated and decommissioned inactive databases and thus saved approximately $400,000 on database, monitoring and backup software licensing and storage.
  • Led the database monitoring project and successfully planned and deployed Confidential in-house monitoring solution to monitor 4,200 production and non-production databases within 50% of planned time, which not only saved $300,000 monitoring tool licensing cost but also improved the monitoring quality with more accurate alerts and thus mitigated risks.
  • Created, documented and standardized various database operation and support best practices, policies and procedures like database build, Disaster Recovery, backup and refresh, patching, health check, auditing, etc. to keep databases in compliance with IT policies.
  • Work with business users, application and project teams to gather data requirements, learn the application process flow, define meta data and identify business rules and implement data rules, design and document application data models; design standards for using normalized data structures, de-normalized structures, and dimensional structures.
  • Developed data governance process and controls and ensure compliance with enterprise data architecture principles and standards for the various systems and components; designed and implemented data security including encryption methods; supported SOX, FDA audit and other internal and external regulatory and compliance inspections.
  • Performed operation planning and governing, assessed current database and middleware system landscape and constructed 5 year operation roadmaps to support business objectives; create database service catalog and model to deliver world-class technology services to the organization.
  • Led web development on Confidential Web Globalization project and successfully launch Confidential 10 country sites and bunches of microsites and desktop websites for IV pump devices and newly released drugs like Precedex, which is Confidential ’s single highest source of revenue globally (11%).
  • Built team structures and hierarchies, created accurate job descriptions for all levels of direct reports; set up performance goals, performed performance review and appraisal, created development plan and held regular one-on-one meetings for all direct reports; promoted out performers, created performance improvement plan for the low performer and provided weekly coaching.
  • Provide team leadership and technical expertise for database support, enhancements and optimization, capacity planning, integrity and security, disaster recovery and high availability implementation; lead performance tuning and troubleshooting efforts of complex database systems.
  • Identify opportunities to innovate, extend and enhance service delivery everywhere possible; keep current with industry trends, evaluate new technologies and recommend appropriate solutions to support company products and services.

Data Architect\Sr. Database Administrator

Confidential, Schaumburg, Illinois

Responsibilities:

  • Developed logical and physical data modelling, performed database design, transforming and data loading process; led, managed and deployed multiple business critical projects including building and implementing new Data Warehouse systems and migrating them from SQL 2008R2 to SQL 2012; highly efficiently and innovatively installed and configured 11 SQL 2012 servers in one week by automating the installation and configuration process.
  • Administer and support large and complex 24x7x365 high-availability production database systems consists of 350 SQL servers plus 30 Oracle instances in a fast-paced multiple hospital environments; installed and configured more than 50 stand-alone and clustered SQL and Oracle database servers; migrated and upgraded numerous databases from SQL server 2000 R2 and 2012.
  • Creatively architected and deployed an enterprise-wide electronic patient medical record database systems across 5 major hospitals; built a complex 4 node Window cluster with 2 stand-alone SQL instances as transaction server and 1 SQL cluster instance as reporting server for each hospital, which saving to the organization about $750,000 on cost; upgraded and migrated database from SQL server 2008R2 to 2012 and synchronized patient data between transaction and reporting server using Windows clustering and SQL Server 2012 AlwaysOn.
  • Successfully delivered multiple Oracle database projects for HR\Payroll ahead of time thus making up for the delay caused by other departments; installed and configured Oracle Disaster Recovery database servers for corporate HR\Payroll database system successfully; duplicated the production databases as a standby databases using RMAN.
  • Actively involved in building DBA team and played a key role in hiring, training, motivating and supervising new and junior team members by providing directions, leading and managing projects, setting goals and priorities, and building and maintaining standards; provided extensive technical and strategic advice and guidance to senior managers and technical resources and ensured project adherence to company wide data and database standards and policies.

Data Architect\Sr. Database Administrator

Confidential, River Grove, Illinois

Responsibilities:

  • Led and managed large and complex Higher Education group Data Warehouse database system upgrade that involves seven database servers and all SQL Server components including SQL Engine, Analysis Server, Reporting Server and Integration Server; acted as all around player as database administrator, system analyst and project manager by evaluating hardware and software requirements, creating upgrade plan, monitoring project process and timeline and implementing the actual upgrade.
  • Architected and implemented new data structures and attributes, transformed and loaded data into corporate Data Warehouse; provided architectural solutions and performed data integration from miscellaneous data sources into shared databases; reviewed and enhanced CRM data models by providing feedback regarding good modeling practices; delivered complete database solutions for new higher education database sub-systems.
  • Performed high-level design of large database systems and led DBA team to deliver large projects; maintained and supported 200 plus SQL Server 2000, 2005, 2008 and 2008 R2 stand-alone and clustered instances and 30 Oracle 9i, 10g, 11g instances on Windows and AIX UNIX in a mixed OLTP and data warehouse environment; provided development support for in-house applications and vendor products.
  • Created and established standard of operating procedures for database support and monitoring; adopted and implemented industry best practices; coached, mentor and facilitated junior team members’ growth and professional development; interacted with cross-functional team and served as liaison to the business for DBA team.

Database Administrator

Confidential, Schaumburg, IL

Responsibilities:

  • Developed, deployed, maintained and troubleshot many SSIS packages for the enterprise data warehouses and online reporting systems; designed, tested and implemented High Availability and Disaster Recovery for production and non-production environment with Transactional Replication, Log Shipping and Database Mirroring; numerous experience in replication rebuild and troubleshooting for enterprise application releases and database patches.
  • Sufficiently architected, planned and migrated several large and mission-critical transactional and reporting production databases from SQL Server and gained Blue Train high performance award; played a key role in enterprise-wide largest database infrastructure re-architecture, upgrade and data migration from SQL Server R2 as well as SAN upgrade and Unisys server replacement.
  • Developed standards, procedures, guidelines, and processes to enable the integration of multiple source databases of enterprise data warehouse; and providing DBMS platform technology recommendations to all major projects; proactively performed database monitoring, auditing and reporting; established standard operation procedures and best practices on database operation and installation; inventively automated SQL agent job failure monitoring and notification and change control tracking by developing and deploying daily reports using SSRS.
  • Administered and maintained overall health of 70 plus production database servers and 200 plus development, test and QA database servers with every feature set of SQL Server including High Availability, Transactional Replication, Log-Shipping, Database Mirroring, Disaster Recovery, Data Warehouse, Backup and Recovery, Integration Service, Reporting Services and Analysis Services.
  • Extensive experience in SQL server 2000, 2005, 2008 stand-alone and cluster installation, configuration, upgrade, and maintenance; efficiently completed complicated SQL 2005 5-instance on 3-node cluster installation and databases migration for corporate email archiving project; productively fulfilled multiple urgent requests on SQL 2005 and 2008 cluster installation with very short notice and received compliments from the application owners.
  • Innovatively developed and implemented dual backup strategies using LiteSpeed new features to satisfy business needs which significantly reduced the daily data loading time for the university group’s data warehouse; creatively simplified and improved the security restoring of 200 database refreshes in non-production environment to achieve centralized and dynamic management; significantly improved database refresh reliability by adding failure detection mechanism and email notification features.

Database Administrator

Confidential, Elk Grove Village, Illinois

Responsibilities:

  • Administered 4 production, 10 plus development and test SQL Server and Oracle database systems; provided consistent 24x7 support to production database systems; installed, configured, managed and supported Oracle 9i, 10g, SQL Servers 2000 and 2005 clustered and non-clustered instances in a SAN environment.
  • Thoroughly evaluated and consolidated the various existing database systems and achieved improved data integrity and eliminated redundant data thereby saving thousands of dollars in annual cost; provided valuable and fundamental information for building future database systems.
  • Successfully migrated production databases from Oracle 10g to SQL Server 2005 using SSMA; performed extensive and various data migration between Oracle servers, from Oracle to SQL Server and the other way around; created numerous knowledge based articles and detailed project plans.
  • Tuned database servers and optimized queries and stored procedures; proactively monitored and analyzed the server load with in-house applications; assisted the development team to identify the performance bottlenecks in database, OS and network.

Database Administrator/Consultant

Confidential, Des Plaines, Illinois

Responsibilities:

  • Efficiently migrated SQL Servers 2000 databases from one healthcare practice management system to another and ensured the integrity and quality of enterprise data; implementation yielded substantial cost savings.
  • Performed administration, monitoring and support to the migrated databases; designed lots of databases, tables, stored procedures, views and functions; documented the database architecture and maintenance procedures.

Database/Web Developer/Consultant

Confidential, Schaumburg, Illinois

Responsibilities:

  • Successfully redesigned and implemented the client’s academic web sites, which enabled more timely updates; installed, configured and maintained the back-end MS SQL Server 2000 databases; created SQL Server DTS packages to export and import data from various source to SQL Server.
  • Evaluated existing data model and redesigned the database structure to stay current with the client’s business requirements; created and modified numerous SQL agent jobs and monitored disk space usage; developed database security policies to ensure proper level of user access.

Database Developer/Consultant

Confidential, Schaumburg, Illinois

Responsibilities:

  • Developed database applications populating data from flat files to MS SQL Server databases using T-SQL and VC++ for the client’s web-based training events; performed installation, configuration and maintenance of SQL Server 2000 production database servers.
  • Developed and maintained the client’s database-driven e-learning website that provided on-line multimedia training efficiently and inexpensively; trained coworkers on database administration, web development, GUI design and implementation.

We'd love your feedback!