Sr Data Platform Engineer - Charlotte, United States - Crown Castle
Description
Position Title:
Senior Engineer, Cloud Data Platform (P4)
Company Summary
Crown Castle is the nation's largest provider of shared communications infrastructure: towers, small cells and fiber. It all works together to meet unprecedented demand—connecting people and communities and transforming the way we do business.
Whenever you make a call, track a workout or stream music and videos, we're the ones providing the communications infrastructure that makes it all possible.
From 5G and the internet of things to drones, autonomous vehicles and AR/VR, we enable the technologies that help people stay safe, connected and ready for the future.
Crown Castle is publicly traded on the New York Stock Exchange (CCI), is part of the S&P 500 and is one of the largest Real Estate Investment Trusts in the US.
We offer a total benefits package and professional growth development for teammates in any stage of their career.Along with caring for our teammates, we're an active member in the communities where we live, work and do business.
We have a responsibility to give back, which we do through our Connected by Good program.Giving back allows us to improve public spaces where people connect, promote public safety and advance access to education and technology.
RoleAs a Sr Engineer, Cloud Data Platform, you will be responsible for migrating existing databases to AWS.
You will design, automate, and manage databases as a service leveraging deep experience in Open-Source database technologies like MySQL, Aurora, PostgreSQL, CloudSQL and other Cloud Native database technologies.
ResponsibilitiesDesign and implement highly available, scalable, and secure database solutions in AWS
Deploy, configure, tune, monitor, and maintain cloud databases in the production, development, and quality assurance environments
Optimize and tune Redshift cluster and queries to support multiple Analytics and Visualization platforms
Implement Redshift Workload Management (WML) to prioritize workloads and manage concurrency issues
Design and Implement Monitoring and Alerting system for AWS Redshift cluster performance and uptime
Design and implement Redshift Disaster Recovery Plan
Partner with developers and other stakeholders to optimize database performance and ensure data integrity
Stay up to date with the latest cloud and database technologies and provide recommendations for improving our infrastructure
Leverage AWS-based architecture and partner with DevSecOps to develop scripts to support continuous deployment process and maintain the environment via TFS/Terraform/Liquibase
Design server/server-less resource requirements for specific applications and performance metrics
Partner with cloud & data architects on database design patterns/models
Partner with application teams on their cloud adoption and application modernization journey
Expectations
Self-motivated individual who can handle ambiguous/undefined problems and think abstractly to deliver results
Demonstrate a strong sense of ownership, urgency, and drive as well as the ability to work well with diverse teams.
Effectively articulate technical challenges and solutions to business users and other technical teamsDevelop compelling insights and logical arguments to persuade others
Demonstrate curiosity and flexibility to diverse styles and perspectives that could drive business outcomes
Mentor team members and conduct periodic learning sessions
Education/Certifications
Bachelor's degree in Computer Science, Engineering, Information Science, Math or related discipline
AWS cloud certifications (Cloud Practitioner and/or Cloud Database)
Experience/Minimum Requirements
8+ years of experience in managing and automating mission critical production workloads on MySQL, PostgreSQL, CloudSQL. Aurora and other Cloud native databases in a large, complex environment
3+ years of experience designing and managing cloud database technologies such as Amazon RDS, Oracle Cloud, Snowflake, and MongoDB
Experience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse, etc
Expertise in database administration for large Data warehouse/datamart implementations including configuration, implementation, data modeling, maintenance, redundancy/HA/DR, security, troubleshooting/performance tuning, upgrades, database, data and server migrations, SQL
Cloud migration experience
Infrastructure as code (IaC) principles and experience with tools such as Terraform, CloudFormation, Liquibase, Flyway or Ansible. Thorough understanding of Software Development Life Cycle (SDLC) best practices.
Comfort and experience working in an Agile environment
Working Conditions:
This is a remote role with the expectation of on-site/in-person collaboration with teammates and stakeholders for moments that matter and may require up to 15-20% travel.
For New York, Colorado, California, and Washington residents - The hiring range offered for this position is $148,000 - $170,000 annually.
In addition to salary, employees are eligible for an annual bonus of up to 20% of annual salary and restricted stock.
Employees (and their families) are eligible for medical, dental, vision, and basic life insurance. Employees are able to enroll in our company's 401k plan.Employees will also receive 18 days of paid time off each year and 12 paid holidays throughout the calendar year.
#J-18808-Ljbffr