Database Analyst (On-site)

• Database administration in SQL Server and/or large Oracle (12c and 11g) Solaris-based production environment including assisting department staff, as directed by the Contract Manager or Functional Manager(s). Including all stages of database implementation and deployments.
• Analysis, review, coordination, and implementation of new databases and server requests.
• Upgrade, manage and troubleshoot Oracle forms and reports, patching process, roles review, audits, and research cloud migration opportunities.
• Monitoring, troubleshooting, and resolving database performance issues, or related problem resolution.
• Provide administration, maintenance and support of server hardware with Sun Solaris operating systems.
• Provide direct support for the SQL Server and/or Oracle databases as assigned by the Contract Manager. The support includes facilitating training and documenting processes.
• Comply with the offices Administrative Policies and Procedures.
• Ensure that the logical data model design adheres to the Departments standard-based upon best practices and guidelines.
• Coordinate and deploy application changes, including Procedural Language/Structured Query Language (PL/SQL) object and data model changes, to production databases following industry best practices and Departments policies and procedures.
• Work with development teams to tune SQL queries and improve performance.
• Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the Department.
• Design, implement and maintain database maintenance scripts, including replication and monitoring.
• Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting of performance issues using appropriate and Department approved tools and scripts, not limited to using the OAM, Databricks, and Synapse.
• Design and maintain automated processes including DBA jobs, DBA scheduler or SQL Server job scheduler, SSIS packages, ETL, pipelines, and CRON scripts.
• Perform quality assurance and validation to ensure solutions meet business needs and comply with standards.
• Provide ongoing support and expertise for business users, addressing issues and identifying opportunities for continuous improvement.
• Coach, mentor, and train the office team members and other department staff.
• Create and maintain technical documentation and Standard Operating Procedures (SOPs).
• Attend and participate in project meetings and provide regular status updates.
• Submit weekly project reports and time sheets.

• 10+ years of IT business/industry work experience.
• 5+ years of experience with SQL Server and/or Oracle database management systems.
• Experience with Sun Solaris operating systems and Oracle WebLogic.
• 5+ years of experience supporting multiple services and multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
• Hands-on experience using Azure Synapse, Data Warehouse, DevOps or GitHub.
• Ability to communicate effectively (verbally and in writing) with department staff.
• Excellent written and verbal communication skills.
• Experience utilizing BI tools (Power BI, Tableau) to provide insights and support decision-making.
• Technical proficiency with T-SQL, PL/SQL, and other database languages.
• Strong leadership skills and experience working with cross-functional teams.
• Preferred Skills and Experience
• Extensive Oracle database administration, 2019 Certified Professional, and/or Certified SQL Server Professional
• Experience leading the planning, design, development, implementation, and maintenance of Oracle relational database management systems.
• Experience leading the installation, configuration, and maintenance of Sun Solaris operating systems and Oracle WebLogic and/or SQL Server. In addition, Fusion Middleware, Apex, and Solaris.
• Experience working in a Unix environment.
• Extensive architecture training and experience diagnosing, isolating, and resolving complex problems pertaining to the database infrastructure.
• Extensive experience writing PL/SQL, SQL, and Oracle stored procedures, functions, packages, and database triggers and/or SQL Server.
• Extensive experience in designing logical databases and data models.
• Knowledge of data privacy and protection initiatives.

Preferred Skills and Experience

• Bachelors or masters degree in computer science, management information systems or equivalent work experience and ten years of work experience in information technology, systems analysis, management analysis, program planning, program research, or program evaluation., * Bachelors or masters degree in computer science, management information systems or equivalent work experience and ten years of work experience in information technology, systems analysis, management analysis, program planning, program research, or program evaluation.

Do you want to make an impact on the world around you? The work we do at Kyra Solutions directly impacts government entities and the citizens they serve. In Transportation practice, our solutions are designed to save lives on the roadways and in our Regulatory practice, we are designing solutions to make government digital for your accessibility. Kyra works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees., Founded in 1997, Kyra Solutions is a national leader of transportation technology and regulatory solutions in government. We specialize in the art and science of digital transformation in government. Our commitment to providing the highest level of service and tailored solutions has supported our consistent double-digit growth for over a decade. We are headquartered in the greater Tampa Bay area with other offices across Florida and an innovation center in Silicon Valley, CA. Because of our dedication to our employees, we have won one of the Best Companies to Work for in Florida 3 years in a row by Florida Trend magazine. Kyra has won numerous other awards including the coveted INC magazine's recognition as one of America's Fastest Growing Companies several years in a row. Kyra's commitment to our employees, to best practices in project management and business analysis, and to solution development has led to our achievement in becoming the first Project Management Institute certified company in Florida. Our proven successful track record has resulted in several prestigious awards including the State of Florida's Diversity Business of the Year Award. We are proud to be a sponsor for the TaxWatch Productivity Awards and partner to Florida TaxWatch.