Bartlett & West is a civil engineering and technology firm with 13 offices in 10 states. We are looking for a Database Administrator I to work in Topeka, KS or Overland Park, KS.
This position will be responsible for administering databases and maintaining existing databases including backups, version control, login management, and performance. The role will also require the development of integration routines and data access components to allow developers and analysts to interact with databases in support of client solutions. Position will work in coordination/collaboration with experienced Database Administrators.
Essential Functions & Responsibilities:
•Administer SQL Server databases in a 4-tier hosting environment.
•Prepare logical and physical database models driven by customer input to deliver high-quality spatial and non-spatial solutions.
•Administer and maintain internal production and development databases including backups, version control, login management, and performance.
•Develop integration routines and data access components to allow developers and analysts to interact with databases in support of client solutions.
Knowledge, Skills, Abilities:
•Familiarity with relational database management systems and ability to interpret data models
•Basic understanding of web application development
•Familiarity with ESRI’s suite of GIS applications with particular emphasis on ArcSDE and geodatabase management
•Understanding of spatial technologies
•Understanding of the Software Development Life Cycle
•Exposure to other database systems, including, but not limited to Oracle, IBM DB2, PostgreSQL, and NoSQL
•Familiarity with ESRI’s Linear Referencing Systems, Workflow Manger, ArcGIS Server, Archiving, Model Builder, and other GIS Services
•Familiarity with Visual Studio Team Foundation Studio andRedGate’s SQL Compare and SQL Data Compare
•Familiarity with designing/building/modifying Extract, Transform, and Load (ETL) processes
•Familiarity with using database management tools and techniques
•Must be able to manage multiple projects and prioritize work items within each project
•Strong writing skills and grasp of the English language, with the ability to document complex and technical concepts to a technical and non-technical audience
•Proficiency in MS Office Suite
•Strong organizational and time management skills
•Evolving creative thinking skills to propose solutions to business challenges
•Effective communication skills (verbal and written)
•Ability to clearly convey abstract or complex database solutions to clients and other staff
•Must be flexible with the ability to quickly learn new technologies, platforms, and concepts and apply them to client solutions with particular emphasis on Geographic Information Systems (GIS)
•Ability to implement a database design
•Ability to collaborate and work with a diverse team spread over multiple office locations
•Ability to communicate system functions and requirements with technical and non-technical teammates and clients
•Ability to adapt to changing requirements as well as working independently, investigating problems, finding and documenting solutions
•Customer focused (internal and external)
•Ability to break down high level tasks into components
•Exhibits initiative, responsibility and flexibility
•Possess unquestionable integrity, ethics, and the values appropriate to the company's culutre; and actively models those values internally and externally
•Results focused with strong attention to detail and accuracy
•Accountability in work performance
•Team oriented with ability to get along with others
Bachelor's Degree required with a focus in Management of Information Systems, Computer Science, or GIS areas preferred.
0-3 years’ experience working with GIS. Experience using ESRI or Bentley software products. Experience with MS Office Suite required. Must have familiarity with database systems, designing/building/modifying Extract, Transform and Load processes. Experience with programming languages strongly preferred.
Must be able to travel in-state and out-of-state on occasion, which usually would consist of visiting other office locations, attending seminars or business meetings. Minimum travel is 10-25% of the time depending on projects.
This job description is not designed to cover or contain a listing of all functions and responsibilities that are required of this position. Employee owners are expected to take on additional responsibilities as requested.
Bartlett & West is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, age, sexual orientation, status as a protected veteran or status as a qualified individual with disability.