Clark B.

Clark B. Email and Phone Number

Lead DBA @ TeleSign
Downey, CA, US
Clark B.'s Location
Downey, California, United States, United States
Clark B.'s Contact Details
About Clark B.

Database Administrator and Developer effective in architecture and implementing technology to achieve organization objectives. Ability to coordinate large implementations which communicating with multiple teams and aligning resources to achieve project objectives. Effective interpersonal and written communication. Capable of multitasking and implementing solutions to support departments and products for scale-able OLTP and BI/Data Warehouse Solutions.• Industries: Telecommunications, Manufacturing, Education, Entertainment, Financial, Distribution. • Project Management, Database Design and Development.• Roles: Contributor, Lead, Manager, Consultant, and Mentor within project and virtual teams..• Provide Feature guidance to reduce Financial costs on Software, Hardware, and Virtualization• Budget Planning and Forecast of long term capacity and resource utilization.• Design High Availability Data Center Environment integrating Cloud and On-Premise solutions_____________________________________________________________________________________SQL Server 2016 / SQL Server 2014 / SQL Server 2012 / 2008 / 2005 / 2000• Analysis Services (SSAS) • Reporting Services (SSRS) • Master Data Services (MDS)• Service Broker • Change Data Capture (CDC) • SQL Optimization• Database Mirroring • Transaction Replication • Merge Replication• Custom Traces • SQL Profiler • Extended Events• Log Shipping • Windows Clustering • Windowing Functions• SSIS / DTS • Windowing Functions • PowerShell, Command Shell• T-SQL, Table Functions • .NET, SQL CLR • Table Partitioning• Column Store Indexes • In-Memory Tables • Stored Procs, Triggers, Views• XML, HTML, • SQL Azure • Amazon EC2 / Amazon RDB (AWS)_____________________________________________________________________________________MySQL 5.7 / MySQL 5.6 / 5.5 / MariaDb• Master/Master Replication • Red-Hat Linux • Query Plan Analysis • Performance Configurations • XtraBackup • Puppet • Git • BitBucket

Clark B.'s Current Company Details
TeleSign

Telesign

View
Lead DBA
Downey, CA, US
Website:
telesign.com
Employees:
587
Clark B. Work Experience Details
  • Telesign
    Lead Dba
    Telesign
    Downey, Ca, Us
    View
  • Telesign
    Manager, Database Administration
    Telesign Jan 2012 - Present
  • Telesign
    Lead Dba (Continued)
    Telesign Jan 2012 - Present
    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
  • Neogov / Governmentjobs.Com
    Sql Dba
    Neogov / Governmentjobs.Com Apr 2011 - Jan 2012
    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.
    View
  • Herbalife
    Manager And Sr. Sql Dba
    Herbalife Oct 2007 - Apr 2011
    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
    View
  • University Of Southern California
    Sql Dba / Manager Of Database Development Team
    University Of Southern California Aug 2004 - Oct 2007
    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.
    View

Clark B. Skills

Microsoft Sql Server Databases Sql Ssis T Sql Software Development Ssrs Data Warehousing Etl Database Administration Integration Web Applications Sdlc Performance Tuning Business Intelligence Windows Server Agile Methodologies Sql Tuning Crystal Reports Visual Basic Disaster Recovery Data Migration Software Documentation .net Data Modeling Project Management Cloud Computing Database Design Mysql Cassandra Stored Procedures Html Vb.net Sql Server Relational Databases Analysis Services Software Development Life Cycle Sql Server Integration Services .net Framework Database Development Xml Dts Replication Mysql Cluster Mariadb In Memory Clusters

Clark B. Education Details

  • California State University, Northridge
    California State University, Northridge
    Accounting And Finance
  • California State University
    California State University
    Finance

Frequently Asked Questions about Clark B.

What company does Clark B. work for?

Clark B. works for Telesign

What is Clark B.'s role at the current company?

Clark B.'s current role is Lead DBA.

What is Clark B.'s email address?

Clark B.'s email address is cl****@****usc.edu

What is Clark B.'s direct phone number?

Clark B.'s direct phone number is +131074*****

What schools did Clark B. attend?

Clark B. attended California State University, Northridge, California State University.

What are some of Clark B.'s interests?

Clark B. has interest in Surfing.

What skills is Clark B. known for?

Clark B. has skills like Microsoft Sql Server, Databases, Sql, Ssis, T Sql, Software Development, Ssrs, Data Warehousing, Etl, Database Administration, Integration, Web Applications.

Who are Clark B.'s colleagues?

Clark B.'s colleagues are Dejana Stojanovic, Vojislav Simsic, Boris Bila, Miroslav Bosanac, Jonathan Gonen, Brandon Stokes, Alisa Maćoš.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.