Samuel Lee Email & Phone Number

West Hollywood, California, Us

-Leading 2 teams with a total of 11 software engineers in support of the Content Management System-Guiding team members with 1on1s, motivational coaching, performance reviews, performance goals, and long-term career goals.-Volunteered for a corporate program to train an associate software engineer-Partnering closely with Product and Project Management leaders-Initiative owner for multiple MongoDB Upgrade projects that required cross-team efforts-Engaged numerous stakeholders to develop MongoDB Upgrade project plan-Prepared weekly team status reports for 2 engineering teams-Maintained relationships with vendor account and support teams-Participated in the company mentorship program and guided a total of 4 mentees-AWS Cost-Optimization--Assisted in the development of data retention policies--Identified 10 PB of wasted S3 spend which will save the company approx $1.8 million/yr--Assisted Ops team with the removal of 5 PB of wasted S3 space for an abandoned project

Santa Monica, Ca, Us

-Transitioned team from Hallmark Labs (division) to Hallmark (parent)-Managing 3 database engineers-Promoted a Sr Database Engineer to Lead-Application Security: Due to departure of staff, asked to step in to organize and coordinate SAST/DAST scan vulnerability remediations by partnering with Information Security team and coordinating with Developer teams.-Helped lead and organize decommission efforts for legacy database assets-Building relationships to cross-organizational leaders to offer assistance for future cloud database migrations-Championing AWS cloud initiatives--Recognized post-transition gaps in cloud administration, governance, economics and security. --Have stepped up to champion cloud initiatives by resetting the partnership with AWS Support Team, researching multi-account administration, driving cost-optimization discussions and promoting cloud best practices to leadership and team members.-AWS Support Team partnership--Rebooted partnership with AWS Support Team following transition and reestablished relationships with multiple AWS Support Team members--Restarted weekly infrastructure/engineering cadence with the AWS Support Team--Championed the AWS Support Team partnership to leadership and other team members--Helped AWS Support Team get Quarterly Business Reviews back on a regular cadence-Cloud Governance, Cloud Economics, Cloud Security--Governance: Cross-team knowledge sharing and gathering ideas for enterprise-wide policies--Governance: Developing Tagging strategy proposal--Governance: Developing Cloud Center of Excellence / AWS Community of Practice proposal--Economics: Helped drive cost-optimization discussions with Finance Team--Economics: Working with Trusted Advisor reports for overspend --Security: Working with Trusted Advisor reports for security risks and partnering with Information Security team to organize security remediation efforts.

Santa Monica, Ca, Us

-Managed a team of 5 database engineers-Reported to VP of Engineering-Led the migration of 48 microservice databases from MySQL Enterprise clusters to Aurora MySQL RDS-Drove cost-savings efforts for AWS database related assets saving the company over $200k+/year-Coordinated with project managers for priorities, coordination and scheduling-Regularly presented team status updates to tech management-Managed team priorities and roadmap-Managed team on-call rotation with VictorOps-Led daily team scrums and weekly team meetings-1on1s with individual team members-Encouraged team members to present demos and knowledge-sharing sessions-Evaluated team members for yearly perfomance reviews-Trained jr database engineer-Organized JIRA boards for team and groomed requirements for tickets-Prepared numerous Confluence documents for database standards, inventory, security, etc.-Organized and coordinated CCPA remediation efforts-Prepared monthly database backup reports for Corporate officers-Assisted CFO and VP with database license options, renewals, and cost estimates-Co-managed BI team due to departure of BI manager-Maintained relationships with database vendors and account managers.-Worked closely with AWS team for Hallmark.-Temporarily took ownership of SAST/DAST scan vulnerability remediations.

Santa Monica, Ca, Us

-Developed and built 5 MongoDB v3.6 3-node clusters with data-encryption-at-rest and SSL requirements using AWS EC2s.-Setup Key Management Interoperability Protocol (KMIP) servers with Gemalto Keysecure to support MongoDB data-encryption-at-rest requirements.-Setup SSL certificates to support MongoDB data-encyrption-in-transit requirements.-Developed installation runbook that allowed other team members to manually build a new MongoDB cluster in 20 minutes.-Migrated 2 MongoDB production databases from 3rd-party DBaaS provider to AWS.-Setup Datadog agents on EC2s and alert monitors for MongoDB.-Developed custom bash scripts for MongoDB daily backup and copy to S3.-Devoloped custom bash scripts for MongoDB log rotation, compression, and archival to S3.-Handled multiple EC2 degredation and node replacements for MongoDB clusters.-Responded to various OOM (out-of-memory) killer incidents for MongoDB nodes.-Recovered failed MongoDB cluster nodes by wiping out the data and rebuilding with MongoDB replicaset replication.

Los Angeles, Ca, Us

-Hybrid role supporting both Data Engineering and DatabasesData Engineering• Analytics Team Support• AWS Data Pipeline: Supported existing pipelines and developed new ones; troubleshoot various issues with failures; improved run times from 4 hours to 1.5 hours by adding date filters in ETL scripts• Tableau Dashboard Project: Setup a process to download and and display on office TVs• Setup a CSV Report Builder process that produced reports and emailed to internal teams (to save the company from having to purchase a lot of expensive Tableau licenses)• ETL Tool search: Lead the POC efforts to replace Data Pipeline• Matillion (ETL Tool): Lead the effort to setup an EC2 instance and POC. Setup production instance. Work with Matillion Support team to address issues. Developed Salesforce ETL job. Developed Google Sheets ETL job. Identified bug in JIRA extract component and developed a workaround.• Data Lake: POC Redshift External Tables and AWS Athena against data on S3.• Data Refresh: Setup a process to refresh data set from production database to redshift• Data De-Duplication: Identified duplicates and setup audit job to trackDatabase Engineering• DevOps & Engineering Team Support• Databases: Postgresql RDS, MySQL RDS, Redshift• Database Backups: developed backup scripts to utilize manual snapshots specific to each database with retention periods and purge policies• Database Upgrades/Patches: Postgresql RDS 9.3 to 9.4; Researched 9.5 and 9.6 upgrades• Database Migration: Researched moving Postgresql RDS from region to region and non-VPC to VPC• Data Retention: Developed a data retention job that alleviated slow query concerns due to high table row count. • SQL Tuning: Tech Session presentations to Engineering. Tuned an 8 minute query down to 17 seconds. Identified poor design causing slow query issues. Took over a complex business query from a developer and figured out why the numbers weren’t lining up.• POC dblink between Postgresql 9.5 and Redshift

Santa Monica, California, Us

Redshift:-Backup: Established automated snapshots and created custom manual snapshot scripts-Business Intelligence Support: Worked with BI team to setup daily jobs, bulk load data, de-dupe data, produce reports, replicate data from external sources-Compression: Rebuilt tables with compression parameters to reduce sizes by 1/3 and avoided expanding the cluster to add space-Data Conversion: Solved ongoing UTF-8 text conversion issues with daily DB2 exports to Redshift.-Data De-Duplication: De-duped data with rank and row_number functions.-Data Export/Import: Utilized COPY / UNLOAD commands to load and dump CSV files-Data Updates: Automated manual update processes that were being manually run every few days on-demand to provide daily data updates. Scripted complex daily update jobs with error handling, S3 copies, COPY commands, backup/purge staging tables, table renames, and weekly backups to S3 and SNS notifications.-Security: Revised users from having full explicit access to role-based access.-Table Backup: Setup table backup scripts for long-term data archiving in S3Aurora/MySQL RDS:-Backups: Established automated snapshots and created custom manual snapshot scripts. Additionally mysqldump backups off replica instance.-Cross-Region Snapshot Copy: Trial-tested for migration purposes-Data Export/Import: Utilizing mysqldump-Data Migration Service: Trial-tested for MySQL to Aurora migration-Data Replication: Setup custom data replication process from Aurora tables to Redshift tables-Migration: Migrated MySQL in us-east region to Aurora in us-west region with mysqldump-Patches: Applied to Aurora-Security: Revised users from having full access and replaced with user and app accounts with limited accessAWS:-EBS-EC2-IAM-Route53: Setup CNAMEs and A records-S3-Security Groups: Improved security by removing open access and whitelisting only office IPs and approved home IPs-SNS

Santa Clara, Ca, Us

• DBA duties included: on-call support, production deployments requiring outages, development of schema changes, deployment planning, SQL performance tuning, data extraction for business reports, version control with github, data updates from external sources.• Upgraded Postgresql databases from 9.3 to 9.4 using Slony.• Research and POC for future database plans in AWS.• Presented at company’s Tech Summit conference.• Reason for Leaving: Company layoffs

Santa Monica, Ca, Us

• Developed Chef recipes and bash scripts to automate re-provisioning of PostgreSQL standby instances in AWS.• Utilized Cloudformation templates and Chef cookbooks to deploy autoscale group instances with EBS volumes for PostgreSQL databases to AWS cloud.• Developed Chef cookbooks to provision customized PostgreSQL 9.2 databases into our private cloud.• Production support of mission-critical databases: Media Website, B2B, Data Syndication, AdTools, Oracle E-Business, OEM Grid Control, ServiceNow, Confluence.• Built Oracle 11gR2 database and physical standbys on SSD. Features utilized included Active Data Guard, Data Guard Broker, Real-Time Apply, RMAN, and Transparent Application Failover.• Primary DBA for data center migration project. Rebuilt and migrated numerous databases to Oracle 10gR2. Developed, tested and executed production website cutover to new database with no downtime.• Primary DBA for database consolidation project which merged 3 legacy databases. Coordinated and executed migration of 18 internal applications and support processes to new database with no major issues.• Primary DBA for Site Operations team that provided ongoing website maintenance.• Primary DBA for Website Point Team tasked to focus on optimizing website performance.• Subject matter expert for various internal databases, processes and procedures.• Major contributor to development of a standardized db release process.• Supported numerous website releases and weekly data refresh processes.• Improved database security by recommending, implementing and enforcing role-based security.• Installed Oracle RAC databases 10gR2/11gR1 on 2 node Redhat clusters with NFS.• Performed Oracle db upgrades from 10gR2 to 11gR1.• Supported Logical Standby for reporting and data replication.• Authored documentation covering standards, procedures, best practices, and db reference material.• Worked with Agile.

Irvine, Ca, Us

Primary DBA support for 40 Oracle databases that supported 6 Distribution Centers, Payroll and Human Resources. Supported application installations/upgrades for Peoplesoft and Kronos. Migrated Oracle 8i to 9i databases for Payroll. Migrated Oracle 8i databases to 10gR2 RAC databases for 6 Distribution Centers. Implemented and administered SOX compliance. Worked with developer teams on numerous projects.

Milton Keynes, Gb

Started as entry-level Programmer/Analyst working on mainframe systems. Developed conversion programs for migration from mainframe to Oracle 8i Parallel Server. Redesigned CICS programs to interface with Oracle databases. Part of migration team executing the cutover to Oracle. Accepted offer to become junior Oracle DBA. Primary DBA for implementation of Retek Distribution Management System. Provided various DBA support: on-call, disk reorgs, sql tuning, monthly partitioning, performance monitoring, and security management.