SQL DBA ONSITE Centennial

This position will be responsible for providing technical database expertise and managing the efforts to import, collect, store, transmit, and use data across the organization. Design, implementation, and administration of databases to support these new systems is an essential function for this position.

• Minimum of 3 years SQL Server Database Administration and Management Tools
• Experience automating in Power Platform
• Experience writing SSIS packages
• Minimum of five years of experience with administering relational database technology

• Installation, support, and maintenance of the database platforms across the organization
• Apply new releases and upgrades and support all products under minimal or no supervision
• Create and manage multiple databases, table spaces, and indexes; maintain databases to current security standards; direct staff in advanced database management procedures and diagnostics when necessary
• Monitor, tune, diagnose, and resolve problems with databases and their performance; develop and maintain a backup and recovery strategy for all databases
• Establish standards and procedures; require a BA/BS or equivalent in Computer Science, a database management certification (preferred) and a minimum of six years of experience with administering relational database technology
• Oversee SQL Developer
• Develop, implement, manage, and maintain databases, data management systems, software, and analytical tools
• Analyze, design, write, document, test, train, monitor, maintain and support databases and database applications across all departments
• Improve efficiencies, enhance analysis, and automate processes relating to data across the organization
• Work as part of a project team to coordinate database development and determine project scope and limitations
• Provide applications support by developing reports, creating and modifying SQL queries and stored procedures, designing and implementing automated processes, modifying and maintaining forms, performing system upgrades, and general troubleshooting
• Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure
• Recommend solutions by defining database physical structure and functional capabilities, database security, data back‑up, and recovery specifications
• Support the transition to enterprise‑class and ERP solutions
• Schedule, plan, and perform testing of new databases and data‑related products and services, identify and troubleshoot errors, and make necessary modifications and corrections
• Development and design of enterprise GIS database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements
• Develop methods for integrating different sources of data from across the organization to enable data‑driven decisions
• Consult with users to determine needs and solutions
• Identify and evaluate industry trends in database systems, anticipate long‑term data needs, and proactively serve as a source of information and advice for OTI management
• Provide technical database expertise and training to internal and external users as required
• Establish technical requirements and policies, and ensure staff, vendors, and clients are in compliance
• Identify and communicate database‑related issues to key stakeholders, including management, development teams, and end users
• Design and maintain quality service by establishing and enforcing organization standards
• Structure data for reporting
• Perform other tasks and duties as assigned
• Maintain, update, and retain records, data, and content managed within the scope of the position

• Bachelor's Degree (or equivalent experience) in Computer Science, Information Systems/Sciences, or a related field, with an emphasis on database design, development, and data management
• Experience with backups, restores and recovery models as designer and process owner
• Experience working with Windows Server OS
• Significant experience with database design
• Experience with database products other than SQL Server a plus

Expert Level

The…