2/20/2023 0 Comments Oracle sql developer mysql![]() Coded PL/SQL batch scripts used to update Oracle 11 database schema objects.Build and maintain database ERDs which were used to plan updates needed for the company’s Federal Sunshine Act compliance.Implemented nightly maintenance on MySQL, Postgres, SQL Server and Oracle platforms.Lead the effort re-coding Oracle stored procedures in order to attain better performance as well as scripts used to identify and purge historical data from the platform.Assisted in patching and upgrades to the Netezza database platform.Reviewed and coded numerous SQL queries for Microstrategy using a Netezza data warehouse backend.Designed, coded and implemented ETL as well as streaming data processes from any number of data sources into a Netezza data warehouse.Implemented high availability, managed master / read slave as well as multi-master database topologies on cloud and bare metal platforms.Implemented changes to the database tier in order to achieve better response times using a load balancer strategy. Managed e-commerce web server and database platform infrastructure using vSphere.Developed ETL and automated workflow processes using SQL Server Data Tools, Astera and Advanced ETL Processor to pull customer, order and order detail data and synchronize with target database platforms.Implemented transactional replication software in order to synchronize SQL Server and MySQL data from the online databases in Chicago to a disaster recovery site located in California.Analyzed query plans and implemented improved indexing strategies which reduced instances of slow client application response times. Captured slow running queries using a combination of Profiler and system DMVs.Set up alerting to the DBA group for various performance degrading events such as low space, blocking, deadlocks, low memory error conditions, failed backups and failed transaction log dumps.Built and deployed SQL Agent jobs used for index maintenance and updating data estimates / statistics. Modified machine configurations in order to optimize available hardware resources. Install SQL Server 2008 R2 and SQL Server 2012 on clustered platforms.SQL Server / MySQL Database Administrator Cache Multidimensional Object Database, CSP and Cache Web services.Post - Relational Object Data Architecture. ![]() Database Disaster Recovery and Business Continuity Planning.Relational Database Design, DataEdo ERD, Bulk Loading Strategies, Index Tuning and Relational OLAP.Database and Query Performance Optimizing Techniques.VB.NET, ADO.NET, ASP.NET, C#, Crystal Reports and SQL Reporting Services.Google Cloud SQL, AWS Relational Databases, AWS Glue, AWS Step, AWS Database Replication and Spectral Core.AWS Relational Databases, Google Cloud SQL, Red Hat, vSphere Web Based Datastore Browser.SQL Server Data Tools, Advanced ETL Processor, Astera Workflow, Talend Open Studio and Talend Service Bus.Oracle 11, PLSQL, Toad for Oracle, Oracle SQL Developer.SQL Server Management Studio, Navicat, Aqua Data Studio Visual Cron, AutoSys, SQL Sentry and New Relic.SQL Server 2008 R2, 2012, 2014, 2016, 2017, MySQL, MariaDB, SQL Lite, Netezza, Dremio and ProxySQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |