Clark B. Email & Phone Number

Downey, Ca, Us

Data Warehouse / Business Intellegence• Extract, Transform, Load, Aggregate and Summarize data for BI Tools• Created denormalized Tables and Table Partitioning to optimize Reporting Structures • Setup and programmed SQL Server Reporting Services• Setup and programmed SQL Server Analysis Services• Converted ETL DTS packages to SSIS Project Packages hosted in SSISDB• Designed LUN Layout and configured Pure Storage Array to support snapshot recovery• Implemented Environment refresh using PowerShell programming and Pure Storage Array Snapshots reduced environment refresh duration from 7 days to 1 day.• Programmed Import process to pull OLTP data into data warehouse and run batch processes to build reporting structures. Programmed import processes to consume both MSSQL and MySQL transaction data.• Programmed Table Partitioning to Archive data off of the Data Warehouse to long term archive• Supported Multi-Terabyte tables and databases, optimized backup solution to reduce backup time from 24 hours to 4 hours.__________Online Transaction Processing MSSQL:• Setup and programmed Change Data Capture services to record changes for import to data warehouse• Setup and programmed Service Broker Services used as a mechanism to synchronize data across data centers.• MySQL: Optimized and Centralized Backups using InnoDbBackupEx using Linux Bash Scripts and Cron Jobs• Implemented Transaction Replication for Scale out Read Performance for transaction processing.__________Online Transaction Processing MySQL:• Configured Multi DC Master-Master Replication and Master-Slave Replication• Identified Performance issues using Linux commands htop, ps, vmstat, iostat, iftop • Leveraged Grafana to build custom graphs to monitor and troubleshoot performance of Linux System and MySQL• Reviewed SQL performance challenges using Explain Query utilized this information to re-write SQL for increased performance, provide recommendations to developers

El Segundo, Ca, Us

OLTP Environment SQL Server 2005/2008 Performance Tuning, Mirroring, Replication, SSIS, SSRS SQL Programming. GovernmentJobs.com is software as a service company which provides support to government agencies with HR services. They have over 10 million login accounts with 10 Thousand new accounts daily. My role as the sole Database support person was to resolve production issues quickly and efficiently on a 24/7 schedule. • Performance Tuning: Identify and produce short, medium, and long term resolutions. Code review and rewrite, Index review and optimizations, Server, Instance, database performance optimizations.• Build a distributed database server farm to off load read only traffic to increase OLTP response time. This included building reporting servers as well as OLTP read only slaves via transactional replication.• Provide a roadmap for high availability environment with detail project implementation plans. Set up database mirroring for high availability and reduce downtime for server upgrades.• Mentor developers on high performance optimization methods for querying data, as well as provide database schema review.• Create and execute custom maintenance strategies which would ensure peak database performance and environment stability. • Create and implement monitoring / alerting services. Reconfigure servers to support early error detection and response.

Los Angeles, Ca, Us

SQL Server 2000/ 2005 & 2008 Custering, Mirroring, SSIS, Replication, Disaster Recovery, Encryption , Security, OLTP & OLAPHerbalife is an international company which generates 4 Billion dollars in sales worldwide. The company is located in 74 countries with an additional 12 new countries opening this year. As the Manager of the SQL DBA team it was my responsibility to guild and Build high availability database solutions to support 24/7 business processes.I was a hands on SQL DBA and Project manager for two teams: SQL DBAS: 5 in the US and 3 in Bangalore India; Enterprise Scheduling: 2 in the US and 2 in IndiaThe SQL DBA team managed 378 instances with 2,500 databases running on 80 Servers a storage footprint of more than 100 TB. All systems were upgraded and moved to high availability solutions. 90 percent of the environment now running SQL 2008.Largest OLTP database in the environment 750 GBLargest OLAP database 1.2 TB• Production Database Server environments were built and maintained in multiple locations.• Upgrade systems from SQL 2000/2005 to SQL 2008• Setup High Availability Solutions using Windows Clusters, Mirroring, and Replication• Setup monitoring of database systems as well as evaluate database hardware performance, identify optimization strategies to maximize server efficiency • Performance tuning high transactional databases • Developed maintenance and backup procedures, change control processes and operational documentation • Collaborated with application development teams in working with databases, planning and implementing production changes, code review, and query optimization.• Initiate root cause analysis and resolution for all the database and application issues • Participate in scheduled and unscheduled system maintenance • 24/7 on-call and off-hour systems support

Los Angeles, Ca, Us

SQL Server 2000/2005 SSIS/DTS, SSRS, .NET, Replication, High Availability, Encryption , Security, OLTP & OLAP Environments • Architect and build database schemas, ensure tight data cohesion between custom solutions and vender products. Design and enforce security standards/protocols including OS and web applications data access methodologies. • Create OLAP data mart to support reporting needs. • Design SSIS Packages to import and export data to and from remote systems and ensure proper scrubbing and integration of the processed data. • Review production errors, identify root cause, resolve data integrity issues and design permanent solutions for referential integrity. • Monitor and enhance database performance through Hardware / OS / Application / Database best practices and application workflow design strategies. • Integrate Vender packages by designing data work flow processes to ensure proper synchronization between the systems. • Maintain all database servers: Production / QA / Development. This included 11 database servers, 100+ custom production databases accessed through web interfaces. Active directory, vender, and ASP integration. • Hired and managed 8 database developers and 2 contractors covering the following functional rolls: Database Developer, Report Analysts, Data warehousing, and Data Quality Assurance annalists, to ensure successful implementation of new databases, enhancements, and the resolution of production issues. • Implement development standards and train staff in all aspects of database development and analysis • Manage all database projects and coordinate with IT Director, Senior Network Engineers, and Project Managers.

Accounting And Finance

Bs, Business Administration Double; Accounting Theory And Practice, Finance