Senior SQL Database /AWS Administrator
Last Updated: 14th January 2021 (over 2 years ago)
Summary
Education
Bachelor of Science, Architectural Technology
Aug 1985
— Dec 1998
Experience
AWS CLOUD ADMINISTRATOR
Mar 2020
— Current
● 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.
SENIOR SQL DATABASE ADMINISTRATOR
Sep 2002
— Current
● 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