Senior SQL Database /AWS Administrator
Last Updated: 14th January 2021 (over 2 years ago)
Address
Category
E-mail
Phone Number
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
Bachelor of Science, Architectural Technology
Aug 1985
— Dec 1998
Experience
City of Orlando
AWS CLOUD ADMINISTRATOR
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.
● 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
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
● 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
