Passionate SQL developer is interested in long-term project. Tech stack: - Microsoft SQL Server, SSMS, SSRS, SSIS, SSMA - Power BI, Holistics.io, Klipfolio - MS Access, MySQL, Oracle, PostgreSQL - ASP.NET Core, Javascript, JQuery, Ajax, Bootstrap, HTML/CSS, D3.js - C# Web API, Swagger, Angular, Material Design - C# Windows Forms development What I can do: - develop Web API - create complex queries, subqueries (MS Server, MySQL, Oracle, Access etc) - develop stored procedures, functions, triggers (T-SQL, PL/SQL etc) - develop entity-relation diagrams (ERD) (tools: PowerDesigner, ER studio, draw.io) - data migration between different RDBMS (for example Oracle and MS SQL Server) - data visualization (Tableau, Power BI) - remove duplicates from database - create all necessary views, indexes - create reports (tools: SSRS, Crystal Reports) - upload data from different sources (Excel, CSV, another databases) - database testing If any questions feel free to ask me.

Experienced DBA and have expertise in 1. MySQL Administration 2. SQL Server Administration 3. MongoDB Administration 4. Postgres Administration 5. Oracle Administration My focus areas are 1. Designing 2. Deployment, 3. optimization of database system performance (Engine Tuning, Queries Indexing, read/write splitting ) 5. Scalability using HA/Replication tool & Techniques (MySQL master-master & master-slave, Group Replication, InnoDB & Galera cluster solutions, SQL Server Always on Availability Group & Always-on Clustering, transactional replication, log shipping & Oracle Data Guard) 5. Security of the Database System 6. Data Modelling (ERD, Schema Designing, Relationship Defining between Entities) 7. Logic creation using SQL queries, T-SQL & PL-SQL 8. Migration & Upgrade Support (on-premise to Cloud, Cloud to Cloud, Database version upgrade) 9. Monitoring (Nagios, Percona Managment & Monitoring (PMM2) and prometheus & grafana). 10. Troubleshooting I have optimized and provided HA/Replication of backend databases for products like CRM, wooCommerce, WordPress, retails, bank, bioinformatics research, and so on. I have experience with monitoring tools. I have experience managing databases both on-premise and cloud, such as AWS, Digital Ocean. We also provide monthly support to the customers freeing you from managing your Database Infrastructure. I have intermediate experience in DevOps tools such as Docker & Kubernetes, CI/CD such as Jenkin, Ansible, Git, Gerrit. I also have experience in AWS VPC, EC2, ELB, Route53, RDS, Subnetting.

I am a computer engineer. I have 11 years of experience as a software developer for a prominent fintech. As a team head, I worked with several teams on different projects and completed them successfully. Here are some quality, 1. Excellent interpersonal communication. 2. Honest and patient. 3. Hard working. 4. Self and a quick learner. 5. Can work under pressure. I have done the below projects as a part of my job. 1.Core Team member(First Mobile Banking Development in the country) a)Main job responsibility: Prepare migration PL/SQL script. b)Database: Oracle. c)Various reports write. d)Testing and bug fixing. e)Documentation. f)Deployed(OS: HP-UX, Oracle WebLogic) 2.Development of an SMS alert system for several applications. a)Language: Java b)Database: Oracle c)Deployed(OS: Linux, Server: Tomcat) 3.Development of API for payment verification with a third party. a)Language: Java, b)Database: Oracle 4.Call center application to integrate to various bank applications. a)Front End(C Sharp) b)Web Service(Java) c)Database: Oracle d)List of applications to communicate a.Core Banking b.Switching System c.Rocket d.Agent Banking System 5.Report writing 6. Dashboard for monitoring system performance. 7. Attendance system and result system for school 8. Inventory system for a company(PHP, Jquery, MySQL). 9. Quiz System for an institute (PHP, Jquery, MySQL). 10. Java spring boot application for waterfall route hosted on AWS.

I have over 22 years of experience in application/ web development, database and IT infrastructure management. I grew my expertise in application development in wide range of areas in JAVA EE oracle forms, asp.net (c#), php, HTML at front end, Besides, I am Caspio certified web developer and successfully implemented many projects using Caspio Data pages. My core competence lies with Database Management and web application development in different platforms. Besides I have experience in Windows network, AD, Exchange. Over all, I can proficiently manage end to end operations of IT solutions as Enterprise level. I am recently focusing on Information Security areas and IT Auditing. Mention-able achievement in my professional careers are: 1) Developed Individual Loan processing system/ Loan Accounting System/ HRMS etc for largest Non Banking Financial Institution (Mortgage Finance) in Oracle 11g and Form 6i and reports 6i, There has been use of Oracle PL/SQL, triggers, functions, procedures in Oracle RAC environment with Data Guard, Also converted some applications in Oracle APEX. 2) Strong exposure on developing responsive Websites/ Web Applications using latest web technologies in different platforms like php/ MySQL, Asp.net/ SQL Server. 3) Completed around 40 projects successfully using Caspio Datapages embedded on different platform. 4) Got Strong exposure on Managing Enterprise network comprised of Window AD, Exchange servers, CIsco Routers, Switches, SAN storage etc. 5) Completed a research work successfully in upwork that deals with comparison of different functionalities between Monetdb Database with Oracle database and SQL server.

I have 17+ years of IT experience in the area Application Development, Systems Integration, Production Support, Application Maintenance and QA projects. I have played the role of Project Manager, Project Lead, Business Analyst, Developer and QA. I have managed complete SDLC for medium sized development projects. I have business domain knowledge in the area of Automotive on-board telematics and IT systems, Pharma Relationship Marketing, Manufacturing Execution Systems and Work and Asset Management. I have actively implemented LEAN practices in Production support projects. My technical skills in Database consultancy/administration/development are as follows 1. Design and development of relational and NoSQL databases (Mysql, Oracle, MongoDB). Production support of Mysql and MongoDB databases. 2. Migrating existing databases to Mysql, Oracle and MongoDB. 3. Configuring monitoring and alerts for database servers. 4. Develop business layer applications in PL/SQL / Mysql procedures and UNIX. 5. Setup and support Mysql HA database cluster in single primary or multi primary mode without changes to your data or tables. 6. Setup and support Mysql master-slave replication for backups and failover. 7. Automated Point-in-time recovery of Mysql databases. 8. Performance tune databases like Mysql and Oracle. My technical skills in REST API/Web Services consultancy/development are as follows 1. Creating high performance, scabale, standards compliant and secure RESTful API for backend and business logic processing as microservices or in monolithic service architecture. My technical skills in System/Devops consultancy/administration are as follows 1. Create solution architecture for Cloud and On-Premise infrastructure based on free and open source software stack. 2. Containerize Mysql and other servers using Docker and/or LXC. 3. Deploying LXC containers to create extremely lightweight and tightly packed virtualized environments to isolate, secure and streamline your IT operations. Running LXC containers have near zero performance penalty. 4. Install and configure QEMU-KVM virtual machines with full inter VM and external networking support, 3D graphics acceleration for GUI based administration. 5. Performance tune your LAMP/LEMP stack for great results. 6. Setup in-memory databases like Memcached or a persistent in-memory database Mysql Memcached plugin for caching or sessions. 7. Setup and maintain secure Email servers using Postfix, Courier IMAP, maildrop, OpenLDAP and Roundcube webmail. 8. Maintenance and administration of Linux servers like setting up firewall, webservers, mail servers, ldap servers, imap servers, automating system admin tasks using shell scripts, applying security updates, install and uninstall of software packages. 9. Setup of Jenkins for CI/CD of complex project workflows. 10. VPN setup ( IKE/IPSec and OpenVPN )

I am professional Database designer, Data Scraper, Data Analyst/Scientist and SQL, PL/SQL, Python Developer with 12+ years of experience. I have worked as data analyst and designed the dashboards using Chartio, Google Data Studio, Oracle Apex, KlipFolio, Periscope and Mode Analytic. I have worked on many databases Platforms like MySQL, Google Big Query, SQL Server, PostgreSQL , Oracle Forms, Reports, and Oracle Business Suite With maturity in design and architecture of the software, I provide a solid and dependable solution. I have Expertise in - SQL, PL/SQL, MSSQL, MySQL, PostgreSQL, Mongo, Python, Google Big Query - Data Scraping, Python Scripting, Automation of manual business process - Google Data Studio, Google Apps, Big Query API, Google Cloud Platform - Dashboard Designing and Data Analysis - Query writing and Performance Optimization ,Creating Procedures, function, views, Triggers etc - Database Administration, Database installation and Server Setup - Database Designing - Linux Installation and Administration

✅ 16,000+ hours and many projects over Upwork ✅ 10+ years of professional experience in full software development life cycle, i.e., software design, development, quality assurance, implementation, and support. ✅ Excellent working abilities in JAVA (J2EE/J2SE), Spring, Springboot, Struts2, Hibernate, JSP, Servlet, JavaScript, JQuery, REST, Angular, React, AWS (S3/Transcoding/Dynamo), NoSQL, HTML, CSS, XML, Android, PowerBuilder 7/9/ 10.2/ 11.5/ 12.5 ✅ Excellent knowledge of relational DBMS (Oracle, MySQL, SQL Server, Sybase) and No SQL(DynamoDB, MongoDB) ✅ Design and development experience in REST APIs ✅ Specialties Enterprise Resource Planning (Development, Implementation & Support) Application Software Development. Customized Application Development. Web Applications Development Systems Integration. ✅ Expertise: 1) JAVA (J2SE, J2EE, Struts, Hibernate) 2) REST API (Spring Boot, Jersey), Swagger 3) NoSQL Database (DynamoDB) 4) AWS (S3, Video Transcoding, DynamoDB, Cognito) 5) Angular, React, JavaScript, JQuery, HTML, AJAX, XML, CSS 6) PowerBuilder(7/8/9/10.5/11.5/12.5, 2019) 7) ERP (Development, Support & Implementation) 8) MySQL 9) ORACLE (9i, 10g, 11g) 10) SQL Server 11) Sybase 12) SQL/ PL SQL

I'm a qualified Full Stack Web Developer with over 11 years of experience and 3 years of remote work on all kinds of smart systems ranging from ERP, CRM, Web Application, Web Services, Micro Services, E-commerce, API, VoIP, IoT, to AI systems. These include design, development, integration, implementation, and documentation projects for governments agencies, corporate businesses, and individuals. Programming languages and applications expertise and skills are as follows: ❇ Design frameworks or template: Bootstrap, Material UI and Tailwind CSS. ❇ Frontend development applications: HTML5, CSS3, TypeScript, JavaScript, ES6, jQuery, Redux, React/NextJs and Angular. ❇ Backend development applications: Node.js, NestJS, JSON, GraphQL, RESTful, and Web API. ❇ Version control: Git. ❇ Database and tools: Microsoft SQL Server, T-SQL, Oracle, PL/SQL, PostgreSQL, PL/pgSQL, MySQL, MongoDB, Entity Framework, Sequelizer ORM, Prisma ORM, Mongoose, SQL Server Management Studio, Oracle SQL Developer, Toad for Oracle, MySQL Workbench and pgAdmin. ❇ Business Intelligence applications: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, and Power BI as well as Pentaho Mondrian and Data Integration. ❇ Application development environment: Visual Studio, Visual Code, IntelJ and XCode. ❇ Cloud Services: AWS, GCP, AZURE, DigitalOcean, Namecheap and Vultr. Please contact me to discuss your projects, and learn more about my past projects, no matter the scale and complexity. I care about the quality of my work and will ensure your project is rigorously completed and fully functional to your expectations.

I have been working with software since 2000, my first tool was Visual FoxPro 6.0, then I start learning Delphi, I have worked in almost all kind of desktops applications Human Resources, Accountants, POS using Visual FoxPro and SQL Server, MySql and Oracle. I started working with .Net Platform near 2004 with C#, I made myself very proficient with this tool and also ASP.net, I got a experience working remotely for a very important companies in the USA like ACS / Xerox, doing multi functional applications with C#, ASP.net also Delphi and AutoIT Script. I have learned JAVA for the mobile device I have already made some Apps, for my own projects and for some employer. Very proficient int Autoit. I took this tools and start working in my own personal projects made with Visual Foxpro and DBF files, I upgraded then to C# with SQL Server, applications like POS, Hotels Managements, Casino's Apps, and varieties of tools for my personal use and my employers. Have a lot experiencing working with SQL Server, Oracle and MySQL. If you need a software developer four your company that can manages C#, Visual FoxPro, Java Mobiles App, AutoIT Script then you can trust me. Also if you need a setup for your applications I can help you with that, using Inno Setup or InstallShield. I'm very responsible person always ready to learn new things and ready to help. In short those are my skills C#(NetCore, WinForm, ASP.net, ETF, Devexpress, WPF, ASP.NETZero) Visual Foxpro Delphi Angular 4 ASPNetZero JavaScript Java(Android) AutoIT Reporting Services Cristal Report Databases: SQL Server(Transac SQL) Oracle(PL/SQL) MySQL Cloud Microsoft Azure ERP's experienced EPICOR ADP WORKDAY SAP

🥇👑 Top Rated Plus 🚀 🏪 🔥 24/7/365 Communication with On-Time 🕘 Delivery ⌛ 🏆🏆 ~3000hrs of Upwork 👑 🏆⭐ 250+ Successful Projects ⭐✨ Successful Freelancer - since ages of oDesk 🛡️ I develop enterprise-grade web applications and web integrations using .NET technology stack with deployment on AWS and Azure. I have delivered products to many clients around the globe including Cognika Corporation, Transfocus Solutions, SalesNexus CRM, TriSys CRM, and ADS Data Direct. While working with Transfocus solutions, I delivered well-matured products to more than 6 Transportation/Logistics customers. My designed SMS-based complaint system can handle 200+ requests per second with optimized complaint flow. I deliver projects on time with 24/7 communication to clients. I am sure, you will feel comfortable working with me. List of Skills - C#, ASP.NET, MVC, .NET Core, WebAPI, WPF, WCF - Java, Ant, Gradle, Android - Bootstrap, JQuery, Angular - PostgreSQL(PL/pgSQL), MS-SQL(T-SQL), Oracle(PL/SQL), MySQL - Amazon MWS, AWS EC2, ECS, S3, RDS, DynaomDB, Redshift, SQS, SNS, SES, CodePipeline, Lambda, API Gateway, CloudFront, ELB, ECR, Lex, Poly - Azure Database, Functions, App Service, Service Fabric, Azure Pipelines, Service Bus, Logic Apps - Jira, TeamworkPM, Trello, Github, Bitbucket - DevSecOps, Docker, Azure DevOps, Jenkins, OWASP ZAP, Postman