GIS ​Geodatabase Administrator

| Greater Boulder Area | Hybrid
Sorry, this job was removed at 11:48 a.m. (MST) on Wednesday, July 18, 2018
Find out who's hiring in Greater Boulder Area.
See all Developer + Engineer jobs in Greater Boulder Area
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Company Description

Zayo Group Holdings, Inc. (NYSE: ZAYO) provides communications infrastructure solutions, including fiber and bandwidth connectivity, colocation and cloud infrastructure to the world’s leading businesses. Customers include wireless and wireline carriers, media and content companies, cloud providers, finance and professional services and other large enterprises. Zayo provides customers with flexible solutions and self-service through Tranzact, an innovative online platform for managing and purchasing bandwidth.

Position Description

The GIS developer will be part of a GIS Development team tasked with the goal of integrating ESRI into Zayo through web, desktop, and portal applications.

Primary Duties and Responsibilities:

  • Administer application and geodatabase security using Active Directory accounts and established ESRI security levels (e.g., users, groups, roles etc.).
  • Develop, implement, and refine commercial off-the-shelf and custom GIS applications, user interfaces, and web services using the latest GIS/web-programming technologies.
  • Collaborate with other GIS and IT staff in the design, development, and maintenance of geodatabases supporting the needs of company-wide web mapping applications.
  • Develop scripts and routines to automate workflow processes for geodatabase and Oracle spatial tablespaces.
  • Collaborate with enterprise IT staff to implement robust backup and recovery procedures for Oracle spatial database, SDE Esri, and restoring system registries as necessary.
  • Reconciling geodatabase versioning of multiple users within a robust Enterprise environment.
  • Provide technical guidance and assistance to staff and customers while integrating all Zayo information systems into efficient and maintainable architectures with the end user in mind.
  • Support and configure multiple geodatabase systems that publish and support company-wide web application REST endpoints.
  • Perform quality control checks of spatial data within Oracle spatial database architecture and Esri SDE.
  • Grant privileges, maintain groups, add users, through Python administrative scripts through database authentications.
  • Daily maintenance in Oracle spatial database working in conjunction with the Esri SDE environment, including effective ways of reducing server strain while providing quick response time in database query ability.
  • Normalizing geodatabase tables within Oracle spatial relationship and object orientation.
  • Familiarity with data types and memory efficiency in data storage best practices.
  • Database integration between systems that like Oracle Spatial, SQL Server, PostGRE
  • Knowledge of SQL Server, Python, MySQL, PHP is a recommended.
  • Provide support for real-time mapping applications.

Additional Responsibilities:

  • Manage and support enterprise-wide ArcGIS SDE databases and related datasets, feature classes, and layers in multiple instances of Oracle (development, testing, and publishing).
  • Draft scripts (SQL, Python, etc) to perform database maintenance, system ETL, and monitor/improve database performance and capacity. Identifies; tests; and resolves complex geodatabase and geospatial issues.
  • Monitor the landscape of GIS data management plans and design support services to respond to these requirements.
  • Participate in geodata repository and data evaluations, metadata creation/updates, data loading, creating geospatial solutions,  and troubleshooting as needed.
  • Mange versioned editing environments by maintained and executing procedures for reconciling and posting versions, as well as compressing the geodatabase, rebuilding database indexes, and using ArcGIS tools to update database statistics.

Qualifications:

Bachelor’s degree in computer science, geography, engineering, or related discipline with a background in geospatial databases and statistical geospatial analysis, with at least 3 years related experience. Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the Zayo.

Technical Experience and Preferred Skills:

  • Knowledge of database and geospatial architectures and data storage technologies
  • Familiarity with operating systems, command prompt solutions, silent installs, bat files, task scheduler, Oracle SQL Developer, Linux, Python executables.
  • Familiarity with SQL, MySQL, PHP, Linux, Python,
  • Familiarity with GitHub, StackOverflow, SourceForge, or similar open source control environments
  • Understanding of Database Standards, Best Practices
  • Provide effective geospatial solutions within the scope of data storage efficiency, lack of service latency, and provide reliable user integration in web maps that support the entire Zayo Enterprise.
  • Experience with REST and SOAP web services
  • Knowledge of geospatial concepts and data types
  • A detailed knowledge of security best practices and operating system authentication
  • Strong analytical thinking and problem-solving skills, attention to detail and accuracy
  • Strong organizational, project/process management, and database maintenance skills
  • Interest in learning, using, and demonstrating software systems/technologies
  • Ability to effectively collaborate and build consensus with a diverse group
  • Excellent technical communication and documentation skills
  • Ability to work well independently and as a team member
  • Experience with other database DaaS platforms
  • Experience administering ArcGIS Enterprise SDE and Oracle spatial databases
  • Experienced with geodatabase system tables and relationships, SDE stored procedures, triggers, and user-defined functions

Physical Requirements:

  • Must be able to remain in a stationary position for extended periods of time.
  • Ability to operate a computer and other equipment on a frequent basis.
  • Ability to frequently communicate with coworkers.
  • Ability to move about.
  • Ability to work across functional boundaries

Rewards

  • Competitive compensation
  • Excellent benefits including health, dental, vision, 401 (k), disability and life insurance
  • Fitness membership discounts
  • Generous paid time off policy including paid parental leave

Zayo is an Equal Opportunity Employer. Zayo does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • ApexLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • SalesforceCRM

Location

Our Boulder campus is located in the 29th Street Mall where employees can benefit from access to restaurants, retail, fitness and more!

What are Zayo Perks + Benefits

Zayo Benefits Overview

Zayo Group is committed to providing our employees with a benefits program that is both comprehensive and competitive. Our benefits program offers health care, dental and vision coverage, as well as financial security to our employees and their families.

Culture
Volunteer in local community
Provides up to 16 hours a year to volunteer in the community
Partners with nonprofits
B Strong, Greenhouse Scholars, A Precious Child, AMP the Cause, There With Care, Boulder Parks and Rec, and many more....
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Flexible work schedule
Remote work program
Diversity
Dedicated diversity and inclusion staff
Highly diverse management team
Mandated unconscious bias training
Diversity manifesto
Mean gender pay gap below 10%
Diversity employee resource groups
Employee Resource Groups Mental Health & Disability Advocacy | Pride | Women's | Multicultural | Veterans | Sustainability
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Flexible Spending Accounts (FSAs) enable you to put aside money for important expenses & help reduce your income taxes at the same time. Zayo employees can contribute up to $2,850 annually.
Disability insurance
Short & Long term disability insurance are a free company provided benefit to all full time employees. They cover 60% of annual salary up to $5000/$10000 monthly maximum payout
Dental insurance
Preventative, minor, and major dental services and treatments are covered under Zayo's plans.
Vision insurance
The vision plan covers routine eye exams and also pays for all or a portion of the costs of glasses or contact lenses if you need them.
Health insurance
Each person's health care needs are different. That's why our medical plan offers multiple options (3) so that you can choose the coverage level best-suited to your personal situation.
Life insurance
Your family depends on your income for a comfortable lifestyle and for the resources necessary to make their dreams a reality! Zayo offers Basic Term Life and AD&D as well as supplemental insurance.
Pet insurance
Offered at a discounted rate to all Zayo employees
Wellness programs
We offer incentives for employees to participate in many wellness activities.
Team workouts
Do you love working out? So do we which is why Zayo offers access to group fitness sessions and company-sponsored events, such as the B Strong Ride.
Mental health benefits
Financial & Retirement
401(K)
Zayo Group offers a 401(k) plan through Fidelity. Eligible employees may join the plan as soon as administratively feasible after their date of hire and may contribute up to the IRS limit of $19,000.
401(K) matching
Zayo matches 50% of employee contributions up to 4% with a cap at 2% match.
Company equity
Performance bonus
Child Care & Parental Leave Benefits
Generous parental leave
Family medical leave
Adoption Assistance
Return-to-work program post parental leave
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Zayo employees receive between 0 and 25 days per year of paid time off based on years of service.
Paid volunteer time
We encourage our employees to give back to our communities by providing 4 hours of Volunteer Time Off per quarter.
Paid holidays
Office Perks
Commuter benefits
Zayo Group offers the option to elect Commuter Benefits which helps you pay for public transportation and parking costs while commuting to and from work using pretax dollars.
Company-sponsored outings
Some meals provided
Company-sponsored happy hours
Happy hours are hosted twice monthly and include alcoholic and non-alcoholic options.
Onsite office parking
Parking is available at Zayo offices.
Recreational clubs
Love sports? So do we! We offer a variety of options to get involved with your co-workers outside of the office.
Fitness stipend
We strongly believe that there is nothing more important than the health and well-being of our employees and families. To promote health and fitness, Zayo has partnered with GymPass.
Onsite gym
Professional Development Benefits
Job training & conferences
Tuition reimbursement
The tuition reimbursement program provides an opportunity for Zayo employees to further their education and to apply to be reimbursed for eligible education expenses.
Lunch and learns
Zayo is committed to providing opportunities for employees to expand and grow their knowledge base through lunch and learn sessions.
Promote from within
Mentorship program
Continuing education stipend
Continuing education available during work hours

More Jobs at Zayo

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about ZayoFind similar jobs like this