 Collaborated in a Cross-Team project to design and develop an AWS & In-House K8 Cluster based PaaS solution using Pulumi as Infrastructure-as-Code (IaC) tool and manage changes using Concourse as the CI/CD pipeline tool.o The PaaS solution included deploying Network Management (Cilium), Certificate management (xPKI), Load Balancing (OIDC), Service Mesh (Istio), S3 bucket, Observability (Grafana), Zero-Trust Security all integrated to allow application teams start deploying code immediately on cloud Strategized an On-Prem to AWS migration plan in consultation with Cloud SMEs and DevOps DB Support teams to design a high availability multi-zoned global footprint with Redis caching and MySQL repository that upgraded application availability to 99.999%  Architected a data replication stream in coordination with DB SMEs to ingest data from AWS & Azure into in-house data warehouse for analytics & metrics reporting that enhanced data consistency by 45%• Conducted an enterprise-wide survey to identify infrastructure resource usage and determine cost reduction opportunities • Used Kubernetes to orchestrate the deployment, scaling and management of Docker Containers.• Worked with the team(s) generate data set to identify opportunities to reduce product licensing cost by 30%• Using the enterprise asset management software, identified orphan targets, or decommissioned but still active targets and created a plan to shut those down, thus reducing Tech-Debt by ~10%• Analyzed user info within all database technologies to determine vulnerabilities and plan a secured remediation path by introducing Identity Governance for databases.• Planning and designing an event-driven architecture using RabbitMQ as the queuing service in collaboration with app architects & DevOps team.• Researched, recommended and implemented a ChatBot solution to empower application teams to remediate BAU tasks, thus reducing service requests by ~30%

Comcast is US’s largest cable service provider with more than 100,000 employees. And the dba team here has 30+ members. Primary role of this position is to provide solution/suggestion on how to help improve performance, plan upgrades and give capacity planning suggestions.RESPONSIBILITIES & ACHIEVEMENTS –● Work closely with application teams as the SME and provide end-to-end solutions to meet business/customer needs● Responsible for creating technical documents. ● Deploy & manage Hadoop cluster in lower env for tests to be eventually deployed to prod cluster.● Providing Hardware, software and system technical analysis and implementation support for system and functionality upgrades● Providing supports to mission critical Databases running on 10g/11g RAC , Data Guard and Golden Gate● Involved in various database migration projects from existing Oracle 10g standalone (VCS) to Linux/Oracle 11g r2 RAC.● Involved in DR testing (Failover/Switchover) for Production databases.● Troubleshoot and remediate performance issues due to Conrolfile Fragmentation● Involved in automation of installation, build, deployment and maintenance operations and procedures● Perform application migration with 0 downtime using Golden Gate. ● Responsible for Performance tuning and troubleshooting for complex database issues.● Investigate H/W and Kernel issues using STrace & Truss.● Responsible for Capacity Planning for newly build databases. Recommend horizontal or vertical scalability of the db tier.● Add/remove nodes from cluster. ● Responsible for creating and implementing backup strategy ● Extensive client interaction through meeting, conference calls / mails. ● Write cron, ksh scripts for various application monitoring requirements.● Write PL/SQL scripts to automate tasks.● Write custom shell scripts to perform backup/maintenance or monitor database stats.

Verizon Business is US’s largest telecom service provider with a huge customer base all across US and also has operations abroad (UK/Germany/Australia). And the dba team here had 20+ members. Primary role of this position was to provide production support on a 24x7 hour basis. RESPONSIBILITIES & ACHIEVEMENTS – ● Install, configure and maintain Oracle Databases and Applications● Apply security patches as and when applicable for the setup using the Opatch tool.● Manage, troubleshoot and resolve oracle database, RAC and applications issues.● Perform database/schema refresh using Export/Import and Data Pump.● Performed TSPITR (Tablespace Point In Time Recovery) for accidentally/wrongly modified tables.● Performed upgrade of Clusterware/ASM/Database from 10g to 11g. ● Migrate Mission Critical database from Solaris 9 with RDBMS 10.2.0.4 stand-alone installation to RHEL5 RAC cluster running 10g clusterware/home.● Monitor ADDM reports to find out slow running queries and suggest or implement the necessary fix to expedite response.● Create and monitor Standby databases● Perform switchover/failover to standby database.● Reclaim space from fragmented sectors of tables which required running the ‘SHRINK’ command on case to case basis.● Support DSS (Data Warehouse) database● Perform recovery in case of disasters using RMAN tool.● Administer 5 Mission Critical Applications under my responsibility● Administer databases ranging from 600GB to 2TB size.● Administer database with VPD (Virtual Private Database). Give users restricted access to tables.● Administer/Monitor Streams setup. Fix issues in case of latency● Open tickets with Oracle Metalink for un-trapped errors and fix issues.● Administer Oracle APEX users. Give necessary grants to users in various workspaces● Perform quarterly maintenance of databases – delete valid rows and reclaim space● Write custom shell scripts to perform backup/maintenance or monitor database stats.

AT&T is US’s second largest telecom service provider with a huge customer base in US and an employee strength of 100,000+. RESPONSIBILITIES & ACHIEVEMENTS -● Tune SQL queries using AWR/ADDM/SQL Tracing to comply with AT&T's Mission Critical Standards. All queries must give result in a maximum time of 1000 ms where row count were in excess of 250 Million in certain tables.● Analyze tables and tablespaces for data fragmentation status and reduce High Water Mark's● Analyze slow performing servers and propose scopes of improvement – DB Changes that can make a difference in performance● Administer databases with size larger than 7 TB, 600+ tables and 200+ user accounts● Create new Databases, Schemas, tablespaces, roles and indexes.● Use Datapump to archive data older than 3 months.● Clone production data to test either by Datapump or RMAN and simulate the production schema statistics for performance testing by application teams.● Use SQL Loader to load data from flat files generated by DB2 running on Main Frame computers.● Generate AWR/ADDM reports to analyze schema Work Load Repository status● Monitor partitioned tables for daily successful partition creation.● Rebuild indexes in case of index failures● Trace alert logs to look back at errors resulting into scheduled job failures.● Help resolve SQL Procedure bugs for Application teams● Kill procedures with bad execution plans and propose better Query analysis reports for improvement of plan● Conduct daily hot backups of live data to enable instant recovery of data in case of disaster (eg tablespace failure), using RMAN incremental Backup procedure.● Write CRON shell scripts to schedule Oracle jobs● Write KSH Shell scripts to generate schema/table/index stat reports, re-build indexes when Oracle reports invalid indexes,● Design/implement tables on test servers in different stages of development by the application team.● Clone DB2 Schema data to Oracle using Oracle Streams