Deleep Augustian
Auckland,AUK
Summary
A proactive and results-driven Database Administrator with over nine years of diverse IT experience, I am committed to making a valuable contribution to an organization's success by applying my comprehensive Data Management skills.
Over nine years of experience in Database Administration, spanning roles in Application Support, Enhancement, Consulting, and Maintenance projects. Proficient in SQL database management systems, encompassing installation, configuration, and ongoing maintenance. Highly skilled in crafting and optimizing complex SQL queries for advanced data analysis and reporting. Adept at performance tuning and optimization techniques to enhance database efficiency and responsiveness. Profound knowledge of database security best practices, ensuring the protection of sensitive data. Expertise in disaster recovery planning and implementation. Solid understanding of database design principles, including normalization and index optimization. Exceptional troubleshooting abilities, consistently delivering timely resolutions to database issues. Proven ability to gather, summarize, and communicate data for senior management's weekly, monthly, and quarterly audit and compliance reporting.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Data Technician
StatsNZ
08.2023 - 12.2023
- Collaborated across cross-functional teams to discern data requirements and needs
- Conducted manual interventions to enhance the quality of census data, ensuring data accuracy and completeness
- Expertly utilized tools such as Salesforce to cleanse and standardize data, resolve duplicates, and enforce data validation rules
- Methodically gathered, processed, and verified data from diverse sources, guaranteeing data accuracy and quality.
Census Data Collector
StatsNZ
03.2023 - 06.2023
- Conducted data collection for the census, ensuring accurate and complete data gathering
- Collaborated with the census team to meet data requirements and ensure data quality
- Applied data validation rules and utilized tools to enhance data accuracy
- Accurately processed and verified data from various sources.
Freelance Consultant - DBA, Cloud Architect (GCP, AWS), Data Migration
01.2018 - 03.2022
- Consulted with multiple companies on data migration projects, bringing extensive experience with GCP services
- Worked on a wide range of GCP components, including Compute, VPC Network, IAM and Admin, Cloud Identity, Stackdriver, Cloud Pub/Sub, Cloud Storage, and Cloud File Store
- Managed the migration of on-premises applications to AWS and GCP public cloud, aligning services with compute, data, and security requirements, and addressing backup and restore issues
- Conducted data migrations from GCS buckets to virtual machines, including the establishment of appropriate firewall rules and instance management
- Oversaw user management in IAM, including policy and role configuration
- Handled all DBA activities and expertly managed Azure Database Migration Service.
DBA
Texas Instruments India Pvt
10.2012 - 06.2016
- Led database administration for Texas Instruments, assuming a pivotal role as Subject Matter Expert (SME) and overseeing a team of seven members
- Orchestrated RMAN migrations for over 1500 databases and worked extensively with the Exadata Machine
- Proactively resolved production stoppage issues and conducted post-review activities
- Managed backup and restore procedures and handled Oracle streams
- Contributed to EBS upgrades, addressed performance issues in factory applications, and closely collaborated with Factory Operation Analysts (FOA)
- Successfully managed the installation, upgrades, and migration of Oracle and SQL databases, including patch updates and data migration from SQL 2000 Server to Oracle 10g Database
- Efficiently set up Oracle 10g RAC with ASM, performed export and import operations, and managed tablespace and data file growth
- Monitored and resolved deadlocks, reporting issues to the development team
- Competently managed AWS services, including EC2 and RDS, along with Azure SQL migration.
DBA
St. John’s National Academy of Health Science
11.2008 - 07.2011
- Played a key role in implementing the SOFSCRIPT Hospital Management Information System (HMIS)
- Migrated SQL Server Database to Oracle Database and implemented RMAN backups for 10g production databases
- Installed Oracle 10g RAC with ASM and performed data migration from SQL Server 2000 to Oracle 10g using SQL Developer Tool
- Managed and tuned database and SQL servers for optimal performance
- Coordinated with server administrators for system-software upgrades and patches
- Upgraded Production Database to different versions and handled the installation of SQL Server 2000 on a 2-node cluster.
Oracle DBA/Trainer
IIHT Bangalore
07.2006 - 10.2008
- Conducted training on various Oracle platforms (9i, 10g) to students from MNCs to universities
- Managed Oracle software installation, upgrade, and patching
- Researched and tested upgrades, cross-platform migrations, and database character set migrations
- Implemented Database Level Security, set up auditing, and managed User Access through roles
- Set up a distributed environment, maintained and monitored snapshots
- Conducted database and SQL level tuning for performance improvement
- Implemented backup and recovery strategies, set up hot backups, and periodic logical backups
- Managed and tuned Rollback Segments for optimal performance.
Volunteer Database Administrator
Bray Theatre Company
03.2024
- Data Cleaning: Reviewing and correcting errors or inconsistencies in existing data
- Data Migration: Transferring data from one system or format to another
- Database Design: Assisting in the design and implementation of database structures, schemas, and relationships.
Education
Master of Computer Application -
Periyar University, Salem, India
01.2005
Skills
- SQL
- Python
- Data Modeling
- Database Maintenance
- Data Storage Optimization
- Team Oversight
- Data Warehousing
- Network configuration
- SQL Proficiency
- Data Analysis
- C
- Oracle
- MS SQL
- PostgreSQL
- MySQL
- Microsoft Power BI
- Tableau
- Advanced Excel
- Windows
- Linux
- Unix
- AX
- Control-M
- ICD Maximo - Ticketing Tool
- Terraform
- SCOM
- MS Excel
- MS Word
- MS PowerPoint
- Internet Explorer
- Chrome
- Firefox
- Safari
- Jira
- GIT Version Control
- GCP
- AWS
- Microsoft Azure
Technical Skills And Knowledge
SQL, Python, C++, Oracle, MS SQL, PostgreSQL, MySQL, Microsoft Power BI, Tableau, Advanced Excel, Windows, Linux, Unix, AX, Control-M, ICD Maximo - Ticketing Tool, Terraform, SCOM, MS Excel, MS Word, MS PowerPoint, Internet Explorer, Chrome, Firefox, Safari, Jira, ICD Maximo - Ticketing Tool, GIT Version Control, GCP, AWS, Microsoft Azure
References
Available upon request.
Certification
- Oracle certified
Timeline
Volunteer Database Administrator
Bray Theatre Company
03.2024
Data Technician
StatsNZ
08.2023 - 12.2023
Census Data Collector
StatsNZ
03.2023 - 06.2023
Freelance Consultant - DBA, Cloud Architect (GCP, AWS), Data Migration
01.2018 - 03.2022
DBA
Texas Instruments India Pvt
10.2012 - 06.2016
DBA
St. John’s National Academy of Health Science
11.2008 - 07.2011
Oracle DBA/Trainer
IIHT Bangalore
07.2006 - 10.2008
Master of Computer Application -
Periyar University, Salem, India
Similar Profiles
Kaufusi KioaKaufusi Kioa
Warehouse Forklift Operator at Allproof IndustriesWarehouse Forklift Operator at Allproof Industries
Shanyah AmituanaiShanyah Amituanai
Babysitter at Olivia HalasimaBabysitter at Olivia Halasima
Parita PatelParita Patel
Franchise Owner at Clean PlanetFranchise Owner at Clean Planet
ANANI FAAFETAIANANI FAAFETAI
Meat Processor at SILVER FERNS FARMMeat Processor at SILVER FERNS FARM
EMMANUEL OWUSU AGYEKUMEMMANUEL OWUSU AGYEKUM
Data Technician at DOUG NEWELL SWARMALYTICS.COMData Technician at DOUG NEWELL SWARMALYTICS.COM