Sam Lightson Email & Phone Number

Philadelphia, PA, US

Atlanta, Georgia, United States

Deployed YugabyteDB Managed on 3 GCP Regions and 3 Availability Zones to support platform HA. Updated PostgreSQL Database for dev and staging environments. Used DataDog to monitor Database and Application performance. Set up a Crossplane universe/multiverse to deploy multiple environments across GCP with Kubernetes clusters. Used Terraform/Githup to deploy.

Nashville, TN

· Set up 3 clusters for Amazon Redshift.· Set up Glue crawler, Glue Catalog, and Glue ETL process to extract data from multiple data sources across different data environments into a centralized Data Lake.· Connect and point AWS Athena into Amazon S3 Bucket Data Lake for complex SQL querying of JSON data formats from AWS Athena.· Create Apache Kafka.

Durham, NC

• · Created and exported RDS Postures database snapshot copies to newly created data lake location in S3 bucket.· Setup datalake by taking snapshot copies from RDS Postgres (production data & K9 dev data) and loading.
• Added Snowflake to our workflow ecosystem to support production activities and simplify reporting works.
• Added SUPER class data type on Redshift to support RDS JSONB data from RDS Postgres Database on Redshift process JSON data on a columnar database format Redshift.

New York, New York, United States

• Used Airflow and FiveTran as ETL pipeline tool for generating, curating and processing data in staging, Development and Production environment. With codes written in Python, Java and SQL.
• Daily backup Aurora RDS databases via AWS Data Migration Service (DMS).
• Run the weekly data release pipeline process using PyCharm for my codes and pushing data into GitHub, while automating / scheduling the release job via Airflow with snowflake as Metadata DB, pulling raw data from AWS.
• Monitor release process via Airflow and Snowflake history.
• Perform data release QA via Snowflake and SIGMA, where I run my queries against the tables in the databases to check data accuracy, before releasing weekly data releases.
• To process the data releases, I use the following technologies and tools in my CI/CD pipeline process: PyCharm as my IDE for Python/SQL codes, GitHub for Git repository in CI/CD pipeline, Airflow for job automation/job.

Syracuse, New York, United States

• Involved in several cloud migration strategy meetings with other teams on Hybrid Cloud migration between on-premises data center and AWS cloud and Google Cloud.
• Provides implementation strategies and best practices on ways to centralize business data in cloud, for business growth projections, business analytics, and other ETL processes that can be used to scale business growth.
• Collaborated with team members to implement security tools like tenable to synch splunk with cloudtrail and cloudwatch, to generate logs from cloud activities for monitoring use.
• Offer security solutions for data protection with several solutions for MFA, SSO etc. implementation to prevent any form of threats and vulnerabilities on business data.
• Worked with the DBA team and other team to create VPCs, security groups, IAM access etc. with EC2 instances in multiple-AZ for QA environment for SQL Server database to support web applications on AWS. Also provided.
• Participated in a several Proof of Concepts (POC) related to security and AWS infrastructure.

Philadelphia, Pennsylvania, United States

Principal Platform Architect at Cabu

Philadelphia, Pennsylvania, United States

Malvern, PA

• Used service now (SNOW) tickets to schedule Production & Non-production takes i.e. patches, upgrades etc.
• Vetted and documented Vulnerability & Remediation cases for 1000+ Ellucian universities / colleges server environments for RDBMS (10g/11g/12c), WebLogic INB/SSB servers, JAVA, Tomcat, Banner server environments.
• Great experience Upgrading and patching to latest release of Oracle Forms, WebLogic, TomCat, Middleware on The Banner environments, my last project patched and updated over a thousand server.
• Patched/Upgraded Oracle RDBMS 11.2.0.4, 12.1.0.2 with July 2016, Oct 2016 & Jan 2017 for 1000+ universities/colleges.
• Patched WebLogic Middleware servers’ for 1000+ universities/colleges server environments (Production/Non-Prod)
• Great experience working in DiDATA / AWS Cloud environments.

Allentown, PA

• Take data pump expdp/impdp backups for database migration.
• Installed multiple Oracle EM Agents and Deployed Agents and databases for all hosts using OMS agents.
• Migrated databases to Amazon Web Services (AWS) RDS/RHEL and EC2/RHEL servers using Data pump.
• Worked on Amazon GovCloud database migration RHEL platform.
• Worked created and supported SQL server database.
• Plugged in many SQL Server environment into Oracle 12c Cloud control platform.

Cleveland/Akron, Ohio Area

• Performs RMAN backups restore, also takes data pump expdp/impdp backups.
• Work on flashback recovery of databases.
• Used Golden Gate for data replication from cross-multiple platform database migration AIX to Red Hat Linux.
• Used materialized Views to reduce query execution time and help with Database Performance.
• Work on Database migration from AIX to Linux Red Hat and prepare databases for AWS cloud test Migration.
• Deployed and synched KeePass to store all passwords securely in an encrypted DB file locked with master pwd.

Marlton, NJ

• Research and document snapshot standby database to support disaster recovery.
• Participate in weekly DBA meetings and offer helpful suggestions on database security for the DISA environment.
• Work as part of a database team with focus on production support
• Review designs, offer alternatives and implement changes to schemas
• Monitor systems for availability, fail-over and replication errors
• Analyze, monitor and tune databases for optimal efficiency

Wilmington, DE

• Used Korn shell scripting with control-m to implemented weekly production code release.
• Provided database support, performance tuning & monitoring daily schedule batch jobs.
• Used Korn Shell scripts to schedule, troubleshoot, reschedule & restart failed RMAN tape NetBackup level 0, 1, & 2 Incremental, differential & archive redo logs backups.
• Modify RMAN backup korn shell scripts by removing or adding flag to script to allow or disallow archive log Korn shell script before restarting failed backups in order to clean-up the archive logs that are filling up.
• Worked with NetBackup team to fix fail backup issues such as Media layer channels etc.
• Fix and re-create index “index unusable” issues, resulting from production release.

King Of Prussia, PA

• Involved in Data Center move.
• Supporting Test, Development and Production databases.
• Used OEM Grid Control & SQL*Plus to manage & monitor 1,000+ production, QA & dev Oracle RAC 10g/11g(10.2/11.2) database between 4 - 32 terabytes sizes on HP-US & AIX platforms.
• Applied quarterly patches to oracle RAC databases, Database replication.
• Trained DBAs at company work locations in Poland, London, Malaysia and India via video conferencing about RMAN disk to disk setup, primary database failovers and Standby db switchover to primary from dry-runs testing.
• Created databases and perform database and schema export/import using Data Pump.

Greater Philadelphia Area

• Participated in weekly on-call database support rotation.
• Supported Test, Quality Assurance (QA), Development and Production databases.
• Upgraded database to Oracle 10g RAC from Oracle 9i.
• Recovered databases from backup via RMAN to upgrade onto Oracle 10g RAC 10.2.0.4 from 9i.
• Installed and deployed agent and configured database into Oracle EM Grid Control.
• Generated database workload statistic report from AWR, ADDM on daily basis and emailed to DBA manager.

Burlington, NJ

• Refreshed and duplicate Oracle 10g RAC 2 node db instance from NetBackup using RMAN.
• Supported Production, Test, QA & development databases.
• Used korn shell script to set up bash Jobs & automatically startup Oracle database services during failure i.e. 8i databases, Oracle 10g CRS, ASM databases, RAC databases, Net services.
• Used korn shell script to administer Oracle Net services.
• Used Oracle EM Grid Control, Quest Central, Performance Analysis and Foglight to monitor database Performance and administer database tasks.
• Used ASMCMD commands to manage ASM & create disk groups, add storage to ASM DBs.

Graduate Certificate - Database Administration With Oracle

Master'S Degree, Database Technologies

Bachelor'S Degree, Computer Science