Sr. Business Analyst at Pyramid Consulting, Inc. in Atlanta, Georgia

Senior Business Analyst

Immediate need for a talented Senior Business Analyst. This is a 12+ Months Contract opportunity with long-term potential and is located in Atlanta, GA. Please review the job description below and contact me ASAP if you are interested. Job
-48051 Pay Range: $55.31/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

• The AWS DBA is responsible for data analysis and database management, database automation in AWS with RDS, Lambda using Python.
• Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.
• Database Administrators are also responsible for understanding, configuring, and managing database administration tools.
• Provides database support for business applications and schedules back up jobs for user databases.
• Provides access control (password resets /account creation/deletion) and checks IP compliance (violation report review, compliance updates and compliance set Client).
• Performs data purging and data replication activities with both on-demand and automated cron jobs.
• Research on connectivity issues and recurring errors in Application database.
• Responds to database alerts and takes appropriate actions.
• Performs database creations.
• Performs performance tuning and troubleshooting for database.
• Performs application database maintenance and provides technical assistance to users.
• Manages database account access and database object changes.
• Ensures that monitoring and alerts are properly in place to meet monitoring requirements.
• Performs application database and OS scripting.
• Reviews Information Protection compliance reports and notifications for individual databases and internal processes (including compliance updates and compliance set Client).
• Performs data purging and data replication activities
• Performs database recovery from logs, hot & cold backups, Export/Imports and Disaster Recovery.
• Performs database creation decommissioning and database updates/migrations to a higher/lower version or cross platform migrations. Also involved in database, schema, and object refresh activities.
• Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, and Cache, logs performance, and recommends effective resource utilization/emergency recovery procedures.
• Implements database security and auditing features and periodic reviews. Conducts root cause analysis for repeated incidents.
• Performs heterogeneous database interface deployment and support for various data interfaces with applications, Middleware interface and functionality deployment with database architecture.
• Plans and develops processes for database updates and migrations to a higher/lower version or cross platform migrations.
• Also, involved in database, schema and object refresh activities.
• Develops capacity planning processes that include monitoring of existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective utilization of resources and emergency recovery procedures.
• Conducts team training and responsible for resource management.
• Research new technologies to address operations reliability and compliance.
• Implement's and performs configuration management of database cluster and replications.

Project Administrator I - HR

• Bachelor of Science degree in Computer Science or equivalent.
• 10+ years as a Oracle DBA, with expertise in design, implementation, backup, recovery, monitoring, and performance tuning.
• 5+ Expertise with multiple AWS DB Services, Lambda creations for automating multiple DB jobs.
• 5+ Database automation in AWS with RDS, Lambda using Python. Preferable:
  Oracle, Postgres, AuroraDB.
• Expertise in high-availability database features, replication, disaster recovery, and live production schema changes.
• Proficiency with cloud-specific technologies (S3, Route 53, Cloud Formation, AWS CDK, AWS Cloudwatch, AWS RDS, AWS Redshift, DynamoDB, Redis), version control tools (Git), and database life-cycle…