| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Senior Database Administrator DeveloperStreet Address 10th stKenosha, WI Street Address
PHONE NUMBER AVAILABLE EMAIL AVAILABLELinkedIn: LINKEDIN LINK AVAILABLEGitHub: github.com/Pr0x1mo/CertificationsCAREER OBJECTIVESeasoned Senior Database Administrator with over 20 years of experience specializing in Oracle and Microsoft SQL platforms. Expert in deploying, managing, and optimizing high-availability Oracle database systems, including proficiency with Oracle Data Guard, Oracle GoldenGate, Oracle Exadata, and Oracle Cloud Infrastructure. Skilled in the design, implementation, and troubleshooting of complex database solutions across diverse applications. Demonstrated technical expertise in developing robust applications using C#, Java, Python, and SQL. Highly experienced in advanced scripting with Shell, Perl, and Python for automation and efficiency improvements. Proficient in web development technologies such as JavaScript, PHP, Node.js, Angular, and REST APIs, enabling seamless system integrations and rich user interface creations. WORK EXPERIENCESenior Oracle Database Administrator Consortiex Milwaukee, WI August 2023 April 2024 Designed and built Oracle databases and tables from scratch, including defining schemas, creating tables, and importing data using SQL*Loader and Data Pump for efficient data migration. Engineered high-availability solutions using Oracle Data Guard and Oracle GoldenGate for real-time data replication and failover capabilities, ensuring zero data loss and continuous availability across distributed database systems. Optimized data storage and performance on Oracle Exadata, streamlining massive data volumes with smart storage capabilities, which significantly reduced query response times and increased processing efficiency. Implemented comprehensive disaster recovery strategies using Oracle Data Guard and ZDM to automate data protection processes, ensuring robust data integrity and minimizing downtime during critical failures. Administered Oracle Grid Infrastructure with ASM & RAC to enhance database scalability and reliability, facilitating seamless data access and workload distribution across multiple servers and storage resources. Developed a specialized reporting database to optimize data access and enhance performance by replicating production database tables into materialized views using Oracle database links, thereby improving reporting efficiency and accessibility. Implemented daily data refresh protocols using SQL and PL/SQL triggers to truncate and reload tables every morning at 7 AM, ensuring up-to-date data availability for business reporting without impacting production server performance. Streamlined reporting processes by transferring operational workload from the production to the reporting database, significantly reducing load times and improving client service efficiency. Engineered and implemented comprehensive automation of daily, nightly, and monthly database tasks using cron jobs, significantly increasing operational efficiency and reliability. Developed and maintained a weekly data scraping and processing system using Selenium and C# to automate the download and secure transfer of data files to a Linux environment, focusing on XML and JSON data formats for seamless integration into SQL databases. Initiated and managed daily web scraping routines using API calls to pharmaceutical device makers, integrating XML and JSON data directly into a newly created SQL table using C# for seamless data management and accessibility. Automated the extraction and deployment of database updates across multiple environments (SIT, Development, and Production) using custom scripts and C# applications, ensuring data integrity and consistency. Authored Bash scripts to dynamically count and insert XML file counts into databases, enhancing real-time data analysis capabilities. Designed a proprietary C# application emulating Toad functionalities for database comparison, effectively managing user, grant, index, PK, FK, and data discrepancies across four distinct databases. Provided cross-departmental support by developing automated testing tools for web applications using Selenium, improving QA processes and website functionality. Contributed to database performance optimization by utilizing Oracle Enterprise Manager (OEM) for analysis and tuning, identifying and implementing necessary indexes to optimize long-running queries.Sr Database Administrator Resurgence Bannockburn, IL July 2018 - May 2023 Built and managed Microsoft SQL Server databases, including the creation of schemas, tables, and stored procedures, and performed data imports using SQL Server Integration Services (SSIS). Data Integration and Analysis: Integrated MSSQL with collection software to automate the import and export of data, leveraging advanced data analysis techniques using R to enhance operational insights and reporting. Document Management Solutions: Developed custom programs replicating Adobe and Foxit functionalities to merge, split, rearrange, and automatically sign PDFs and legal documents, streamlining document handling processes. Web Integration: Coded Node.js applications for automatic uploading of PDFs and legal documents to designated websites, improving efficiency and compliance with data handling standards. Web Scraping and Data Collection: Utilized Python to design and implement web scraping tools for collecting data and census information, supporting strategic decision-making by providing timely and accurate data. Automation Across Departments: Authored programs that automated routine tasks in accounting, paralegal, and docketing departments, significantly reducing manual workloads and enhancing departmental productivity. Sr Database Administrator Developer McDonald's Chicago, IL March 2018 - July 2018 Database Management: Served as a Senior DBA for Oracle, Microsoft SQL Server, DB2, and PostgreSQL databases. Built and managed Oracle databases, including creating schemas, tables, and managing data imports using SQL*Loader and Data Pump. For Microsoft SQL Server, designed and implemented databases, created tables, and automated data imports with SSIS. PostgreSQL and DB2 Integration: Implemented and managed DB2 and PostgreSQL databases to support various applications. Developed ETL processes to move data between DB2, PostgreSQL, and other databases, ensuring data consistency and availability. Performance Monitoring: Utilized tools like pgAdmin and IBM Data Studio to monitor database performance, optimize queries, and ensure high availability. Regularly performed tuning and optimization tasks to enhance database efficiency. Data Automation and Integration: Developed SSIS packages to automate the import of data into SQL Server and PostgreSQL, facilitating timely report generation on predefined schedules. Departmental Automation: Automated processes for a department of 20 accountants using a combination of R, C#, and Excel, significantly increasing efficiency and accuracy in financial reporting. Scheduled Data Management: Engineered and implemented SQL job procedures to execute daily tasks, including data combination, appending, updating, and exporting to individual Excel workbooks for enhanced report accessibility. Code Translation and Upgrade: Translated and converted numerous programs from VBA macros to C# applications, modernizing legacy systems and improving application performance and maintainability Developer Sr DBA Addison Group Chicago, IL May 2016 - April 2018 Database Management and Maintenance: Performed daily operations on Microsoft SQL Server, Access, DB2, and PostgreSQL, including importing, updating, and dropping tables to ensure optimal database performance and data accuracy. Advanced Data Handling: Developed complex SQL queries and VBA macros to enhance functionality and user interaction within Access and Excel. This included creating forms and automating data processes to streamline workflow efficiencies. Application Development: Gained significant experience in designing and developing Access databases and applications specifically tailored for data transformation processes in an engineering firm. Design and Automation: Specialized in table and report design, utilizing VB modules and .NET to automate various functions, significantly improving report generation and data handling capabilities. PostgreSQL and DB2 Utilization: Maintained PostgreSQL and DB2 databases to support cross-departmental data needs. Developed data migration scripts to transfer data between these systems and other databases, ensuring data integrity and accessibility. Developer Sr DBA First Midwest Bank Chicago, IL June 2014 - February 2016 Database Design and Migration: Successfully built a Microsoft Access database from scratch and migrated the data to Microsoft SQL Server, enhancing data management and scalability. Fraud Analysis: Executed complex queries in archival DB2 and PostgreSQL databases, exporting results to Excel using R to identify patterns of suspicious behavior indicative of fraudulent activities. Fraud Department Collaboration: Acted as a supervisory link between the IT and fraud departments, delivering critical reports generated with Excel macros, Access, DB2, and PostgreSQL. These reports analyzed client behavior, transaction timings, amounts, and frequencies, both domestic and international. Automation and Efficiency: Developed and implemented macros in Excel for automating research on fraudulent behaviors and streamlining account opening and closing procedures. Software Testing and Disaster Recovery: Tested software applications for errors, documenting issues to refine disaster recovery protocols. Financial Reconciliation: Managed and balanced general ledger accounts using custom SQL scripts and R tools designed to ensure financial accuracy and integrity. Compliance and Audit Support: Conducted research and ran specialized queries in DB2 and PostgreSQL to support audit activities, ensuring compliance with regulatory standards. Training and Development: Authored and updated a comprehensive training manual for new hires, facilitating quick adaptation to proprietary software and processes.Oracle & MS SQL DBA Insight Global Chicago, IL April 2013 - June 2014 Database Architecture: Architected and constructed Oracle, Microsoft SQL Server, DB2, and PostgreSQL databases from the ground up, establishing a solid framework for scalable data storage and access. Schema and Table Design: Created schemas and tables, tailoring the database structure to meet the specific requirements of business applications and ensuring optimal data organization and retrieval. Stored Procedures and Functions: Developed and maintained stored procedures, functions, and triggers to automate tasks, enhance performance, and enforce business rules within the database environment. User Management: Managed user accounts and security by creating roles and user profiles, assigning permissions, and ensuring compliance with data security and access policies. Backup and Recovery: Implemented and maintained backup and recovery strategies for DB2 and PostgreSQL to protect data integrity and availability, minimizing potential downtime and data loss. Performance Tuning: Conducted performance tuning and optimization activities, including index creation and query refinement, to improve database efficiency and response times. Collaboration and Integration: Collaborated with development teams to integrate databases with enterprise applications, providing expertise in SQL and database-driven technology solutions. Database Migrations: Facilitated database migrations and upgrades for DB2 and PostgreSQL, ensuring seamless transitions with minimal impact on business operations. Data Integration: Utilized SQL Server Integration Services (SSIS) and Oracle Data Pump for data migration from various formats, specializing in handling complex data sets stored in IDX and DAT files used by collection software, ensuring accurate and efficient data integration into Oracle, Microsoft SQL Server, DB2, and PostgreSQL. Real-time Data Integration: Leveraged Oracle GoldenGate for real-time data integration across heterogeneous databases, ensuring continuous data availability and minimal latency. Documentation and Training: Provided comprehensive documentation and training to IT staff and end users, enhancing understanding and efficient use of database resources.Database Administration Eastern Florida State Melbourne, FL August 2008 - June 2012 System Configuration and Maintenance: Configured and maintained relational database systems, including DB2 and PostgreSQL, to support academic and administrative operations, ensuring high availability and performance for critical educational processes. Security Management: Implemented robust security measures, managing access controls and user permissions to safeguard sensitive data and comply with educational privacy regulations. Backup and Disaster Recovery: Developed and executed data backup strategies and disaster recovery plans for DB2 and PostgreSQL, protecting data integrity and minimizing potential downtime in case of system failures. Performance Optimization: Performed regular database performance tuning and optimizations, monitoring system performance, and adjusting parameters to enhance data retrieval and processing speeds. Support and Training: Provided ongoing support and training to faculty and staff, enhancing their ability to effectively utilize database technologies for educational and administrative purposes. Software Upgrades: Managed database software upgrades and patch applications for DB2 and PostgreSQL, ensuring systems were up-to-date, secure, and operating efficiently. Integration: Collaborated closely with IT teams on integrating databases with other educational technologies, facilitating a cohesive technology environment across campus. Query and Report Development: Assisted in the development and maintenance of complex SQL queries and reports, supporting strategic initiatives and operational decision-making with accurate data insights.Database Administration Union Planters Bank Miami, FL May 2005 - Nov 2008 Database System Design: Spearheaded the design and deployment of robust database systems, including DB2 and PostgreSQL, enhancing data storage solutions and supporting high-volume banking transactions. Schema and Object Model Engineering: Engineered and refined database schemas and object models for DB2 and PostgreSQL to ensure optimal performance and alignment with the banks evolving data needs. Security Protocols: Established and enforced database security protocols, implementing stringent access controls and audit mechanisms to meet regulatory compliance standards. Backup Solutions and Disaster Recovery: Orchestrated effective backup solutions and disaster recovery plans for DB2 and PostgreSQL, ensuring swift recovery and continuity of banking operations during unplanned downtimes. Performance Tuning: Tuned and optimized database performance by analyzing workloads and adjusting server configurations for DB2 and PostgreSQL, leading to improved efficiency and reduced operational costs. Technical Support: Delivered technical support and expert advice to bank staff, facilitating the resolution of database-related issues and promoting efficient use of data resources. Application Integration: Led the seamless integration of banking applications with DB2 and PostgreSQL database systems, enhancing data interoperability and supporting real-time transaction processing. Infrastructure Maintenance: Directed the periodic updates and upgrades of database infrastructure, meticulously planning and executing maintenance tasks to minimize service disruptions. Modern Data Management Practices: Advocated for and implemented modern data management practices, including the adoption of SQL Server Integration Services (SSIS) for complex data migrations and integrations, adapting to the bank's technological advancements. Real-time Data Synchronization: Drove initiatives for real-time data synchronization and integration using advanced tools and practices, ensuring the bank's data landscape was continuously aligned with operational requirements and business strategies. Skills: Languages: Java, vb.net, VBA, JavaScript, Python, C#, C++, T-SQL, PL/SQL, and R, with applied experience in data science, machine learning, and system automation. Frameworks: Node.js, Angular.js, and React.js, with a strong foundation in responsive and interactive design principles.Technologies: In-depth knowledge of SQL, DB2, Postgresql, Oracle databases, Microsoft SQL Server, and .NET framework. Skilled in developing and integrating REST and SOAP APIs for web services.Specializations: Proficient in Object-Oriented Programming with a focus on scalable and maintainable code structures. Expertise in Machine Learning, from linear models to deep learning, with hands-on experience using Python for predictive modeling and data analysis. Well-versed in Artificial Intelligence concepts and applications, including natural language processing and computer vision.Data Engineering and Analytics: Skilled in designing and managing data workflows using Apache Airflow, ensuring efficient orchestration of ETL pipelines. Experienced with Apache Kafka for building real-time data processing pipelines and streaming applications. Proficient in utilizing Apache Spark for large-scale data processing and analytics, with a solid understanding of Spark fundamentals and performance optimization. Competent in leveraging BI tools and technologies for data visualization and business insight generation.Projects: Web Automation: Developed various web bots using Puppeteer and Node.js for form filling and data uploads, significantly reducing manual labor and time requirements. Document Handling Application: Created a C# application that replicates functionalities of Adobe and Foxit for document management, incorporating OCR and machine learning for signature placement. Data Scraping: Engineered Python bots to scrape data for zip codes, median incomes, stock prices, and credit scores, enhancing data-driven decision-making. Email Automation Bot: DesignedEducation: A.S. in Computer Science Mathematics, Eastern Florida State College, 2008 - 2010, Melbourne, FL |
