Address
Form of work
SalaryOverview:
What you'll be challenged to do:
Primary Responsibilities (others may be assigned):
Qualifications:
TranSystems is proud to be an equal opportunity / affirmative action employer and ensures nondiscrimination and equal employment opportunity in all programs and activities in accordance with all applicable laws and regulations. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sex, age, national origin, pregnancy status, marital status, sexual orientation, genetic information, citizenship status, disability, protected Veteran status or any other status protected by law. In compliance with the Immigration Reform and Control Act of 1986, we will hire only U.S. citizens and aliens lawfully authorized to work in the United States (if the position is or will be one which is subject to U.S. law).
As the employer of choice, we are committed to action and strive for a company that reflects the vast diversity of our country and the communities we serve. TranSystems is committed to embracing diversity in all forms, including race, culture, age, sexual orientation, gender identity, disability, veteran status, thought and religious background. We acknowledge the impacts of prejudice and discrimination on historically underserved communities. We commit to establishing a more diverse, inclusive and positive work environment that drives innovation.
Recruiters or staffing agencies: TranSystems is not obligated to compensate any external recruiter or search firm who presents a candidate, their resume, or profile to a TranSystems employee without 1) a current, fully-executed agreement on file and 2) being assigned to the open position (as a search) via our applicant tracking solution.
We are excited to share once again TranSystems has been recognized as a top 100 design firm by Engineering News-Record in 2023. For more than 50 years, TranSystems has committed to a mission of performing engineering and architectural planning, design, and construction solution services in a manner that is both safe and in compliance with all applicable regulatory and client requirements. At TranSystems, we have established and continue to nurture a culture that is committed to providing quality services for our clients. We’re looking for top talent to grow with our firm.
Responsibilities:What you'll be challenged to do:
Whitney, Bailey, Cox & Magnani, LLC, now a division of TranSystems, is excited to announce we are actively searching for a GIS Database Administrator to join our award-winning team.
Primary Responsibilities (others may be assigned):
- Perform DBA responsibilities for production, test and development Oracle databases version 19c.
- Install and upgrade Oracle, applying quarterly Oracle Critical Patch Updates (CPUs).
- Monitor server disk space usage and automated OEM jobs, RMAN backup reports and logs and export log files.
- Create and modify automated Recovery Manager (RMAN) database backups in OEM, datapump exports, and PL/SQL procedures, DOS .bat files and other various programs.
- Monitor database performance using OEM grid control13c, Quest TOAD, Quest Spotlight on Oracle and SQL Developer.
- Perform database performance tuning that includes tuning developers SQL programs and providing alternative SQL statements that result in improved performance.
- Using tuning tools such as Quest SQL Optimizer, TOAD, Oracle performance Tuning and Diagnostic Pack, applying recommended SQL Profiles, applying Oracle optimizing hints and creating indexes on appropriate columns.
- Maintain, create and schedule automated database full and incremental Recovery Manager (RMAN) backups in OEM13c. Candidate needs to have proven experience in Oracle RMAN features, RMAN parameters and commands and the ability to create ad hoc database backups and restores and perform Point In Time (PIT) recoveries. At present, the databases range in size from approximately 15 GB to 3TB.
- Create and maintain Oracle datapump exports and metadata exports and scheduled them to run in OEM13c. Must also perform user requested datapump exports manually as needed as well as datapump imports.
- Maintain Database Disaster Recovery Procedures.
- Create and maintain documentation for restoring RMAN backups, applying CPUs, upgrading databases, various PL/SQL procedures, and regular ArcGIS-related procedures.
- Develop database user requested ERD diagrams and workflows using SQL Developer Data Modeler or TOAD Modeler.
- Assist developers in resolving ESRI GIS problems and errors.
- Assist developers in query tuning and problem resolution. This includes applying appropriate indexes, implementing Oracle SGL Profiles, using Oracle Hints and providing alternative SQL statements to improve SQL performance.
- Troubleshoot and resolve database issues and errors by reviewing database alert.log files and trace files.
- Create and review log files for automated monthly RMAN validations on backups to ensure they are valid for restoring.
- Create, assign and maintain database user accounts, roles, grants and privileges.
- Reconcile, post and compress geodatabases on a daily basis, troubleshooting issues as they arise.
- Create, delete, consolidate events in Esri Roads and Highways
- Maintain data and data integrity in geodatabases, scripting updates and providing backups to file geodatabases where appropriate.
- Create scripts to geolocate data in appropriate projections for incorporation into existing spatial tables.
- Initiate, support and maintain versioning (both branch and traditional/hierarchical) on spatial databases.
What you bring to our firm:
- B.S. degree in computer science or related field
- 8 years of experience in business process re-engineering
- 6 years of experience managing, installing, and upgrading and Oracle database environment
- 5 years of experience in reengineering large scale business processes
- 5 years of experience with Esri ArcGIS Server
- 5 years of experience deploying applications that utilize Oracle Connection Manager
- 3 years of experience with Esri Roads and Highways
- 3 years of experience creating RMAN scripts for backing up data
- 3 years of experience with Commvault backup and recovery systems or similar
- 3 years of experience with database tuning and capacity planning
- 3 years of experience with database backups and recovery
- 3 years of experience with Windows Server Datacenter 2016
- 3 years of experience with OEM tools (13c) and Oracle Grid Management Server
- 3 years of experience working with TCP/IP and DNS
- 3 years of experience with Oracle 19c or higher and their management packs
- 3 years of experience in applying Oracle quarterly Critical Patch Updates (CPU’s) and other patches as needed and required
- Actively engages multiple perspectives when solving problems, seeks to learn from peers, and encourages reciprocal learning among team members.
- Actively advocates for full inclusion in the workplace, fostering an environment that welcomes diversity and values equity for all employees, partners, clients, and the communities that TranSystems serves.
What we’d prefer for you to bring to our firm:
- DoT (Department of Transportation)
- Familiarity with Esri’s ArcGIS Catalog (through ArcGIS Pro or Desktop)
- Solid knowledge of both database and system performance tuning using Spotlight, TOAD, SQL Optimizer Tuner, Oracle Enterprise Manager Performance Tuning Pack, etc.
- Installation, configuration and upgrading of Oracle server software and related products.
- Installation, configuration, and support of Esri ArcGIS Server / ArcSDE and related products in a geodatabase setting.
- Oracle Connection Manager (supporting public facing applications)
- Windows and Unix experience
Working Conditions: An inside office environment when at Client's office. Lifting: 10-20 lbs. Occasional overtime required.
TranSystems is proud to be an equal opportunity / affirmative action employer and ensures nondiscrimination and equal employment opportunity in all programs and activities in accordance with all applicable laws and regulations. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sex, age, national origin, pregnancy status, marital status, sexual orientation, genetic information, citizenship status, disability, protected Veteran status or any other status protected by law. In compliance with the Immigration Reform and Control Act of 1986, we will hire only U.S. citizens and aliens lawfully authorized to work in the United States (if the position is or will be one which is subject to U.S. law).
As the employer of choice, we are committed to action and strive for a company that reflects the vast diversity of our country and the communities we serve. TranSystems is committed to embracing diversity in all forms, including race, culture, age, sexual orientation, gender identity, disability, veteran status, thought and religious background. We acknowledge the impacts of prejudice and discrimination on historically underserved communities. We commit to establishing a more diverse, inclusive and positive work environment that drives innovation.
Recruiters or staffing agencies: TranSystems is not obligated to compensate any external recruiter or search firm who presents a candidate, their resume, or profile to a TranSystems employee without 1) a current, fully-executed agreement on file and 2) being assigned to the open position (as a search) via our applicant tracking solution.
