Crown Castle
Sr Data Platform Engineer
Crown Castle, Charlotte, North Carolina, United States, 28245
Position Title:
Senior Engineer, Cloud Data Platform (P4)
Company SummaryCrown 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 AWSDeploy, configure, tune, monitor, and maintain cloud databases in the production, development, and quality assurance environmentsOptimize and tune Redshift cluster and queries to support multiple Analytics and Visualization platformsImplement Redshift Workload Management (WML) to prioritize workloads and manage concurrency issuesDesign and Implement Monitoring and Alerting system for AWS Redshift cluster performance and uptimeDesign and implement Redshift Disaster Recovery PlanPartner with developers and other stakeholders to optimize database performance and ensure data integrityStay up to date with the latest cloud and database technologies and provide recommendations for improving our infrastructureLeverage AWS-based architecture and partner with DevSecOps to develop scripts to support continuous deployment process and maintain the environment via TFS/Terraform/LiquibaseDesign server/server-less resource requirements for specific applications and performance metricsPartner with cloud & data architects on database design patterns/modelsPartner with application teams on their cloud adoption and application modernization journeyExpectationsSelf-motivated individual who can handle ambiguous/undefined problems and think abstractly to deliver resultsDemonstrate 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 othersDemonstrate curiosity and flexibility to diverse styles and perspectives that could drive business outcomesMentor team members and conduct periodic learning sessionsEducation/CertificationsBachelor’s degree in Computer Science, Engineering, Information Science, Math or related disciplineAWS cloud certifications (Cloud Practitioner and/or Cloud Database)Experience/Minimum Requirements8+ 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 environment3+ years of experience designing and managing cloud database technologies such as Amazon RDS, Oracle Cloud, Snowflake, and MongoDBExperience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse, etcExpertise 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, SQLCloud migration experienceInfrastructure 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 environmentWorking 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
Senior Engineer, Cloud Data Platform (P4)
Company SummaryCrown 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 AWSDeploy, configure, tune, monitor, and maintain cloud databases in the production, development, and quality assurance environmentsOptimize and tune Redshift cluster and queries to support multiple Analytics and Visualization platformsImplement Redshift Workload Management (WML) to prioritize workloads and manage concurrency issuesDesign and Implement Monitoring and Alerting system for AWS Redshift cluster performance and uptimeDesign and implement Redshift Disaster Recovery PlanPartner with developers and other stakeholders to optimize database performance and ensure data integrityStay up to date with the latest cloud and database technologies and provide recommendations for improving our infrastructureLeverage AWS-based architecture and partner with DevSecOps to develop scripts to support continuous deployment process and maintain the environment via TFS/Terraform/LiquibaseDesign server/server-less resource requirements for specific applications and performance metricsPartner with cloud & data architects on database design patterns/modelsPartner with application teams on their cloud adoption and application modernization journeyExpectationsSelf-motivated individual who can handle ambiguous/undefined problems and think abstractly to deliver resultsDemonstrate 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 othersDemonstrate curiosity and flexibility to diverse styles and perspectives that could drive business outcomesMentor team members and conduct periodic learning sessionsEducation/CertificationsBachelor’s degree in Computer Science, Engineering, Information Science, Math or related disciplineAWS cloud certifications (Cloud Practitioner and/or Cloud Database)Experience/Minimum Requirements8+ 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 environment3+ years of experience designing and managing cloud database technologies such as Amazon RDS, Oracle Cloud, Snowflake, and MongoDBExperience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse, etcExpertise 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, SQLCloud migration experienceInfrastructure 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 environmentWorking 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