Syed Abdul Aziz
Senior Cloud Database Site Reliability Engineer
Sandy,UT
Summary
Results-oriented Cloud Database Engineer/Architect and Leader with over 16 years of experience in database administration, cloud migrations, and IT infrastructure optimization. Proven expertise in Oracle DBA, PostgreSQL DBA, AWS Cloud, OCI Cloud, Kubernetes and Terraform with a track record of implementing cost-saving solutions, enhancing database performance, and leading high-impact projects for critical industries like BFSI and finance. Recognized with multiple client and team awards for exceptional performance and leadership.
Overview
16
16
years of professional experience
4016
4016
years of post-secondary education
Work History
Senior Engineer, database
Galileo FT/Sofi
01.2020 - Current
- Company Overview: Galileo Financial Technologies, which is a subsidiary of SOFI
- Spearheaded Oracle GoldenGate migrations, successfully transitioning databases from on-premises to cloud environments
- Built and optimized Oracle RAC environments to enhance database scalability and reliability
- Mentored junior engineers, driving technical growth across the team
- Automated database backups, upgrades, and monitoring via Enterprise Manager and Terraform, reducing downtime by 25%
- Created Kafka streams integrated with Oracle GoldenGate for seamless data ingestion, improving data access for developers by 30%
- Key Impact: Delivered zero-downtime migrations and achieved 100% compliance with audit requirements
- Build, provision and support new RAC environments
- Providing Database resiliency and quality of service
- Database SOP (Standard Operating Procedures) proposal, implementation, and documentation
- Installation, configuration, administration of Oracle 9i, 10g, 11g, 10g RAC, 11g, 12c and 19c RAC database in Unix/Linux and Windows environments
- Expertise in using oracle Export/import, Datapump, RMAN utility to migrate data across schemas, take backups and restore
- Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases and working with cellcli utility
- SQL Tuning using Explain plan, TKPROF with SQLtrace
- Installing PostgreSQL on Windows and Linux environment
- Deep understanding of PostgreSQL Architecture, Cluster, Directory Layout, Configuration Files
- Create PostgreSQL Database objects, user, schema and privileges
- Using PSQL command line interface and Working with PG system catalog
- Performing CRUD operations in PostgreSQL
- Extensive knowledge on Table inheritance, Partitioning and copying the table in PostgreSQL
- Performing tablespace maintenance activities, performing backup and recover in PostgreSQL
- Good concepts on PGADMIN utility and interface
- Worked on all the PG_ utilities including PG_DUMP, PG_DUMPALL, PG_RESTORE, PG_BASEBACKUP
- Working knowledge of Dockers and Kubernetes
- Understanding of concepts of K8S
- Worked on deployment of PODS in production environment in Kubernetes
- Worked on setting up of Kubernetes services(ports/network)
- Creating Infrastructure as a code using Hashicorp terraform, initializing, validating and applying terraform code for creation of AWS infrastructure resources
- Mainly RDS instance and respective required resources like VPC, subnet, route53, RDS instance, s3 bucket
- Created a Kafka stream with source as Oracle database and the ingest through oracle Goldengate Bigdata connector as producer to get the required data in Kafka stream and provided the JSON format output for the developers to consume
- Extensive knowledge of dockers and Kubernetes and how the service works, along with kubectl and required utilities to work with
- Deep knowledge on CI (Continuous Integration) and CD (Continuous Deployment) methodologies with Jenkins
- Worked on AWS RDS instances including PostgreSQL, Oracle
- Worked on AWS DMS for migration POC between databases
- Install & manage VLDB [Very large database] Oracle Cluster Database for high performance & highly scalable financial system
- Performance tuning of Oracle environment including fast changing SQL statements
- Assist in completing quarterly & yearly audits for SOC and PCI certification
- Performed Datadog YAML configurations for Oracle RDS instance monitoring
- Ensure database roadmap activities are completed on-time
- Galileo Financial Technologies, which is a subsidiary of SOFI
Senior Technical Support Engineer
Oracle America
01.2016 - 01.2020
- Working as a Senior Technical Support Engineer in Scalability (RAC) and Storage group of Oracle
- Handle various complex RAC/Storage issues daily from different customers, which are mostly Severity 1 24x7 Service Requests
- Imperative in resolving several system down scenarios for various customers
- Mentoring junior team members in various technical and support functions
- Collaborating with various entities internally in the company and externally
- Every Service Requested is treated as a project and handled as such collaborating with the customer
- Provide design/best practices consultation to various customers through SR
- Handholding through critical issues till the problem is resolved
- Handling complex RAC issues like production down for big engagements, highly escalated and visible SRs
- Designing systems/consulting to customers regarding systems design through Service requests
- Working as a Senior Technical Support Engineer in DBaaS group of Oracle
- Supporting Database as a service component on the Oracle cloud infrastructure and Oracle cloud infrastructure-Classic
- Designing the IP network to create the DBCS service in OCI-Classic
- Dealing with all the issues related to both the console and the CLI to help customer in all aspects for DBCS service
- Creation of DBCS instance on OCI-Classic and creation of DBsystem in OCI both from console and with rest API
- Troubleshooting issues related to the security lists and routers
- Configuration of local peering between the VCNs using local peering gateway
- Configuring the remote peering between the VCNs of different regions for network connectivity between 2 VCNs using DRG
- Creation of VPN IPsec tunnel between the on-premise network and OCI network to establish connectivity from on premise to OCI
- Scheduling of DBaaS backups
- Migration of on-premise Oracle databases to cloud
- Worked on issues related to autonomous data warehousing and autonomous transaction processing
- Worked closely with Operations to help resolve the infrastructure related issues on DBAAS environments
- Worked on Transparent data encryption
- Working understanding of Oracle Key Vault(OKV)
- Worked closely with development to help file the bugs and get the fix for customer
- Implemented Client side and Server-side Native encryption through sqlnet.ora and also implemented converted that to TLS based network encryption
- Worked on few of the load balancer issues that customer required for database connectivity
- Worked on Patching related issues on Oracle DBaaS service
- Supported Exadata C@C customers on DB related issues
- Creation and attaching of block volume to the DBCS instances
- Storage of required files in object storage with high availability of files across the region
- Worked on high priority SRs from TOP ACCOUNT customers for quick resolution of cloud issues
- Monitoring the DBCS instance with EM console
- Worked and Supported ADW and ATP environments
- Worked extensively on setup, Installation and administration of Autonomous Transaction Processing and Autonomous Data Warehousing
IT ANALYST
TCS
01.2009 - 01.2016
- Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production 24
- 7 production Support for mission critical production systems of Oracle 8i/9i/10g/11g and database creation
- Implemented Oracle DataGuard for disaster recovery, ensuring 99.9% availability for mission-critical systems
- Optimized database performance through partitioning, indexing, and advanced tuning tools (AWR, ADDM)
- Migrated legacy databases to Oracle 11g and 12c, modernizing enterprise systems and reducing maintenance costs
- Automated routine DBA tasks with Grid Control, saving 20% of operational time
- Configuration of OEM alerts & jobs for db
- Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
- Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata
Education
Master Of Science - Embedded Systems
Manipal University
Manipal, KarnatakaBachelor of Engineering - Computer Science & Engineering
Visvesvaraya Technological University
Belgaum, Karnataka05-2007
Skills
Team leadership
Management skills
Leadership skills
Quality control
Team management
Project coordination
Performance monitoring
Process development
Risk analysis
Training and mentoring
Project management
Resource management
Technical presentation
Deadline management
Cost analysis
Cross-functional collaboration
Design verification
Work prioritization
Problem-solving
Time management
Continuous improvement
Team building
Team collaboration
Affiliationscertifications
- OCA 10g
- OCP 10g
- OCP 11g
- Oracle certified Autonomous Database Specialist 2019
- Oracle Certified Solution Architect Associate 2019
- AWS Certified Solution Architect Associate 2020
Technical Skills
- OS-LINUX,Sun Solaris,AIX,OEL,RHEL,Windows
- Monitoring- Oracle Enterprise Monitoring,Datadog,Splunk.
- IDE/Client tool- VisulStudio Code,Toad,SQLDeveloper
- Change,Incident,Project Management- Jira,Service Now,Remedy
- Devops Tools- Terraform,Dockers,Kubernetes,AWS Cloud,CI-CD
- Data Stores- Oracle,PostgreSQL,MongoDB
Timeline
Senior Engineer, database
Galileo FT/Sofi
01.2020 - Current
Senior Technical Support Engineer
Oracle America
01.2016 - 01.2020
IT ANALYST
TCS
01.2009 - 01.2016
Master Of Science - Embedded Systems
Manipal University
Bachelor of Engineering - Computer Science & Engineering
Visvesvaraya Technological University
Similar Profiles
Melynn GrayMelynn Gray
United States Army Family Readiness Group at Ft. Campbell; Ft. Leavenworth; Fort BlissUnited States Army Family Readiness Group at Ft. Campbell; Ft. Leavenworth; Fort Bliss
Palash AgrawalPalash Agrawal
Summer Camp Instructor at Galileo Summer CampSummer Camp Instructor at Galileo Summer Camp
RaShaan DavisRaShaan Davis
Director at Galileo Learning/Independent SchoolsDirector at Galileo Learning/Independent Schools