Senior SQL Database /AWS Administrator


Last Updated: 14th January 2021 (about 1 year ago)

Address
United Kingdom

E-mail
Locked

Phone Number
Locked

Gender
Male

Age Range
55 to 64

Qualification Level
Degree

Languages
English, Spanish

Summary

Versatile, results-oriented Senior Database Administrator. Almost 30 years of hands-on professional work experience across an array of industries including government, telecommunications, entertainment and finance. Extensive skills, including management, database administration, development and architecture.

Education

New York Institute of Technology
Bachelor of Science, Architectural Technology

   Aug 1985
— Dec 1998

Experience

City of Orlando
AWS CLOUD ADMINISTRATOR

   Mar 2020
— Current

● Manage Amazon Web Services - ELB, EC2, Route 53, CloudWatch.
● Expertise in architecting secure VPC solutions in AWS with the help of Network ACLs, security groups, public and private network.
● Create 23 buckets and also managing policies for S3 buckets.
● Created Linux and Windows virtual machines with Amazon Lightsail.
● Create Lightsail WordPress serverless sites, SSH, DNS Zone, Static IP setup.
● Build and deployed .NET application, LAMP Stack Web App and Drupal Websites using Amazon Lightsail.
● Create snapshots and amazon machine images (AMls) of the instances for backup and creating clone instances.
● Create and maintain user's accounts, profiles, security, rights disk space and process monitoring.
● Created MySQL, PostgreSQL, Microsoft SQL using Amazon RDS.
● Provide technical support by troubleshooting day-to-day issues with various Servers on different platforms.
● Manage systems routine backup, scheduling jobs, enabling system logging and network logging of servers for maintenance.

City of Orlando
SENIOR SQL DATABASE ADMINISTRATOR

   Sep 2002
— Current

● Responsible for the management of 70 SQL servers supporting OPD, OFD, Finance, Venues, Fleet facilities, Technology management, GIS, Traffic and application development.
● Extensive experience in performing DBA administrative functions including backup and recovery, database refresh, DB migration, encryption, database security, index maintenance, DBCC, DB installation/configuration/upgrades, capacity planning and monitoring database growth.
● Diagnosed and resolved technical hardware and software issues involving SQL servers, such as VMware resource allocation for SQL and application issues.
● Extensive experience with replication and high availability technologies including clustering and database mirroring.
● Configured and used the following for various projects: Database Mirroring, Database Engine Tuning Advisor (DETA), Profiler, DTS to ETL package conversion, SQL Server Business Intelligence Development Studio (BIDDS), MS Data Tools, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
● Idera SQL Diagnostics Manager V9.0 & V10.0, Quest Spotlight Cloud V 1.0.4.1241 & Spotlight Enterprise 12.4.0.24

Ad
Ad
Ad