Experienced Database Specialist with a proven track record in the information technology and data services industry. Proficient in Oracle Database Administration, SQL Server Administration, Reporting Services (SSRS), MySQL Administration, SQL (Queries, Performance Tuning, Monitoring), Python, CSV, JSON, Reports (Power BI, Tableau), and Cloud platforms (AWS, Azure, OCI). I have a strong background in data modeling/warehousing and database administration, with an Associate's degree from Universidad Jorge Tadeo Lozano in Bogota, Colombia.
About this Gig:
In this package, I offer the following services:
- Performing administration tasks in SQL Server, Oracle, MySQL, PostgreSQL, Db2, and MongoDB.
- Handling administration tasks in Azure, AWS, and Oracle Cloud.
- Writing complex SQL and NoSQL queries.
- Conducting health checks and performance tuning.
- Creating reports using SQL Server Reporting Server, CSV, and JSON formats.
- Setting up Always On availability groups for your databases.
- Establishing failover cluster instances.
- Implementing various replication types or mirroring.
- Developing migration plans for SQL Server, Oracle, MySQL, PostgreSQL, and MongoDB.
- Creating backup and maintenance plans for your databases, including integrity checks, full backups, transactional backups, and index rebuilds.
- Setting up and configuring cloud or physical servers required for the environment.
Database Administration Tasks:
- Relational and non-relational database administration tasks.
Expertise:
- Administrator
- Backup & recovery
- Database design
Database Types:
- Centralized database
- Distributed database
- And more
Compare packages to find the best fit for your needs.