| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Database Engineer Empowering Data-Driven Decisions
EMAIL AVAILABLE | PHONE NUMBER AVAILABLE | Rochester NY,Street Address
SUMMARY
I m an experienced Database Engineer with over a decade of hands-on work designing, developing, and optimizing complex
database systems. Throughout my career, I ve worked with high-volume transactional systems, built efficient data warehouses,
and improved performance through SQL and PL/SQL optimization. I ve led teams, developed disaster recovery strategies,
and ensured security compliance across different industries. My expertise includes Oracle technologies like Oracle RAC
and automated database monitoring, and I ve always focused on keeping systems running smoothly and securely. I m
passionate about turning business needs into scalable, reliable database solutions that support data-driven decisions and
ensure seamless collaboration between development and operations teams.
SKILLS
Database Operations: SQL, PL/SQL, ER Diagrams, Data Modeling, Normalization and Denormalization,
Stored Procedures, Triggers, Functions, API Integration, NoSQL Databases (Mongo-
DB,Cassandra, Redis), Database Migrations, Database Schema Optimization
Database Administration: Oracle RAC, Data Backup/Recovery, Partitioning, Data Replication, Database Cluster-
ing, Database Sharding, Licensing Management, High Availability Solutions, Database
Capacity Planning
Performance Tuning: Query Optimization, Indexing, Capacity Planning, Load Balancing, Query Execution
Plans, Memory Management (SGA/PGA in Oracle), Parallel Query Execution, Perfor-
mance Profiling Tools (AWR, ADDM)
Security: Data Encryption, User Authentication, Access Control, Role-Based Access Control
(RBAC), Vulnerability Management, Database Activity Monitoring (DAM), Audit
Logging, Security Compliance (GDPR, HIPAA)
Disaster Recovery: Data Replication, Failover, Backup Strategies, Point-in-Time Recovery, Oracle Data
Guard, Multi-Region Failover, Snapshots and Clones, High Availability Clusters
Data Warehousing: ETL Processes, Data Integration, Real-Time Reporting
Version Control: Git, CI/CD for Databases
Automation: Oracle DB Tools, Shell Scripting, Database Monitoring Tools (OEM, Nagios, Zabbix),
Backup Automation, Ansible, Puppet, Automated Scaling Solutions
PROFESSIONAL EXPERIENCE
Senior Database Engineer Jan 2022 - Present
Self-Employed
Designed, implemented, and optimized complex database architectures to support high-volume transactional systems.
Developed highly scalable and performant SQL queries, ensuring optimal database performance.
Led the migration of legacy systems to modern databases (e.g., Oracle 19c), improving overall efficiency by 30%.
Conducted capacity planning and database tuning to handle growing workloads with zero downtime.
Established robust disaster recovery strategies, implementing data replication and failover systems.
Managed security protocols for database systems, ensuring data integrity and compliance with industry standards (e.g., GDPR)
Project: Global Transaction System Optimization
Redesigned and optimized a global transaction processing system for an e-commerce platform.
Integrated real-time data validation and transactional consistency checks.
Achieved a 40% reduction in query processing time through advanced indexing and query optimization.
Outcome: Reduced system bottlenecks, allowing for seamless handling of 10 million transactions/day.
Database Developer Lead Dec 2019 - Dec 2022
I2C Inc
Spearheaded the development of custom database solutions, tailoring systems to specific business needs.
Led a team of 8 database developers, ensuring best practices were followed across development and deployment.
Implemented advanced PL/SQL procedures and triggers for complex data processing, boosting processing efficiency by 25%.
Automated routine database tasks such as backups, monitoring, and data warehousing processes using Oracle tools.
Developed detailed technical documentation and provided training to junior developers.
Implemented database version control systems, ensuring smooth deployment of database updates.
Project: Data Warehousing for Business Intelligence
Designed and implemented a high-performance data warehouse for financial data analytics.
Integrated data from disparate sources into a centralized warehouse for real-time reporting.
Designed ETL processes and automated data loading for daily financial reporting.
Outcome: Reduced reporting time from 6 hours to 45 minutes, improving decision-making speed for executives.
Database Analyst/Database Administrator May 2016 - Dec 2019
Engro Digital
Monitored and maintained database systems for optimal performance, resolving database issues quickly.
Developed database maintenance plans, ensuring consistent backups, restores, and performance tuning.
Analyzed system performance, identifying and resolving bottlenecks through indexing, partitioning, and query optimization.
Conducted database security audits, ensuring compliance with company policies and industry regulations.
Designed and implemented database backup, recovery, and archiving strategies, ensuring data integrity.
Project: High Availability Setup for Critical Systems
Set up a high-availability Oracle RAC (Real Application Clusters) for mission-critical systems.
Implemented replication and failover mechanisms to ensure zero downtime during maintenance or hardware failure.
Configured automatic monitoring and alert systems for potential performance issues.
Outcome: Achieved 99.999% uptime for critical database systems, minimizing potential business disruptions.
EDUCATION
Bachelors of Science Computer Science
University of Colorado Boulder
CERTIFICATIONS
Microsoft Certified: Azure Database Administrator Associate, 2020 IBM
Certified Database Administrator DB2, 2017
|
