Analyst, Database II

About the Role

A typical day as a Cloud Database Analyst II involves working closely with stakeholders to define business and technical requirements for cloud-based data solutions. The analyst ensures that proposed database architectures and configurations align with both customer objectives and enterprise cloud standards. They spend time managing and optimizing cloud-hosted databases such as AWS RDS or Azure SQL, writing and tuning SQL queries, and using monitoring tools like CloudWatch or Azure Monitor to track performance and availability. They may also support large-scale cloud IT projects by providing input on data architecture, backup and recovery strategies, and high availability configurations. In addition, they help prioritize analysis activities, contribute to planning sessions, and may automate routine tasks using scripting languages like Python or PowerShell. While the role is primarily technical, it also requires strong communication and collaboration skills to guide teams and ensure that database solutions meet both functional and strategic goals.

Responsibilities

• Analyze and develop complex logical and physical database designs, data models, and relational data definitions in support of corporate and client information systems requirements.
• Ensure that department standards for data are adhered to in constructing data management programs and tools.
• Perform regular monitoring, maintenance, and housekeeping for performance, capacity, and troubleshooting of assigned databases.
• Mentor less experienced personnel.
• Define data architecture standards for the organization, structure, attributes, and nomenclature of data elements (20%).
• Design, develop, test, and implement new database objects (tables, views, indexes, databases, etc.) and administer existing architectures for performance and maintenance-related issues (20%).
• Analyze and recommend best practices to prevent potential database issues, such as performance degradation or potential loss of service, and recommend actions to fix issues when problems occur (20%).
• Recommend methods to recover or improve databases, including analysis/review of vendor products.
• Provide input into complex decisions related to data architecture, infrastructure, and/or administration (15%).
• Consult with information systems areas on database issues and proposed changes.
• Recommend tuning to databases and queries when they are not performing to customer requirements.
• Analyze and recommend upgrades to database software and components based on security requirements, new technology, or evolving application system requirements (15%).
• Analyze and recommend capacity planning (SAN storage) based on captured growth trends and monitoring.
• Review database environments to ensure they meet security controls and audit requirements; continually mitigate identified risks and vulnerabilities (15%).
• Ensure recoverability of databases by creating, scheduling, and monitoring database backups for dependent systems.
• Support management on enterprise-wide and departmental goals and objectives.
• Provide education and information on security policies, practices, and awareness programs.
• Provide estimation on work efforts and recommendations on training plans for less experienced staff.
• Lead database migration and deployment of lift-and-shift projects to cloud platforms.
• Design and implement high-availability (HA), backup/restore, snapshots, and disaster recovery (DR) strategies for cloud-based databases across multiple regions.
• Enforce cloud security and compliance standards (IAM, VPC policies, data classification).
• Automate infrastructure provisioning using Infrastructure as Code (IaC) tools like Terraform, ARM Templates, or CloudFormation.

Requirements

• Cloud Data Migration & CI/CD Experience.
• Agile Experience.
• Familiarity with Jira and Confluence.
• Expertise in backup/recovery, data replication, failover, and cross-region availability.
• Hands-on experience with cloud database platforms (AWS - RDS, Aurora, DynamoDB, or EC2-hosted databases, Azure SQL, or Google Cloud SQL).
• Experience managing and optimizing cloud-hosted relational databases, including provisioning, configuration, and performance tuning.
• Strong SQL performance tuning, indexing, and proficiency in writing complex SQL queries, analyzing execution plans, and optimizing performance across large datasets in cloud-native or hybrid environments.
• Experience with Infrastructure as Code (IaC) tools such as Terraform, ARM Templates, or CloudFormation.
• Solid understanding of data security, encryption, and compliance requirements (HIPAA, PCI, FedRAMP, NIST 800-53).
• Familiarity with database monitoring and management tools like CloudWatch, Enhanced Monitoring, Performance Insights (AWS), Azure Monitor, or third-party solutions (e.g., SolarWinds, Redgate).
• USA residency requirement for background screening; contingent personnel who are foreign nationals must have resided in the US for at least three (3) of the last five (5) years prior to assignment.

Skills

• Knowledgeable in constructing data marts, data architectures, and operational data stores.
• Good business analysis, data acquisition, and access analysis and design skills.
• Able to provide input into complex decisions related to data architecture.
• Able to relate knowledge of security issues for data management to less experienced personnel.
• Experience with relational (e.g., Oracle) and non-relational databases in the cloud and on-premises for handling semi-structured or unstructured data in cloud-native applications (nice to have).
• Cloud certifications (nice to have).
• Data warehousing or analytics integration (e.g., Redshift, QuickSight, Glue) (nice to have).

Schedule

• Hours: 8:30 a.m. to 5 p.m., with possible overtime when needed to meet project timelines.
• Onsite is highly preferred; partial and remote candidates will be considered.
• Interviews: Onsite for local/partial candidates; remote for non-local candidates.