Total Required Experience in Years: 5%2B Years
Mode of Work: Onsite
The Advanced Database Administrator will perform enterprise database planning, design, administration, monitoring, optimization, and operational support across SQL Server, Oracle, and GIS/spatial database environments. The role requires strong expertise in relational database management, production troubleshooting, performance tuning, SQL code reviews, database design, and support for application enhancements and modernization initiatives.
Perform daily database administration and operational support.
Plan, design, implement, and support enterprise database structures.
Administer SQL Server, Oracle, and GIS/spatial database environments.
Monitor database health, availability, capacity, and performance.
Perform database performance analysis and tuning.
Troubleshoot complex enterprise production database issues.
Develop and maintain database administration procedures and technical documentation.
Conduct SQL code reviews and recommend performance improvements.
Support database activities related to application enhancements and application rewrites.
Design and maintain relational database structures.
Develop complex database specifications.
Analyze business processes and workflows to design efficient database solutions.
Support ESRI SDE Geodatabases and ArcGIS environments.
Assist with training and mentoring technical staff.
Collaborate with Project Managers, Business Analysts, Data Analysts, developers, and infrastructure teams.
Ensure database solutions comply with established enterprise standards.
Support enterprise database modernization initiatives.
Evaluate and recommend database performance improvements.
Estimate effort and timelines for database administration and analysis activities.
Assist lower-level database analysts with technical issues.
Support database infrastructure activities as required.
Participate in quality assurance and database validation activities.
Maintain technical standards, procedures, and operational documentation.
Minimum 5 years of combined Database Administration experience .
Expert-level experience with SQL Server 2012 and above .
Strong experience with Oracle 10g and above .
Strong understanding of relational database management systems (RDBMS).
Experience with relational database architecture, design, and administration.
Experience performing:
Database Performance Monitoring
Performance Tuning
SQL Code Reviews
Production Troubleshooting
Database Design
Database Administration
Ability to independently diagnose and resolve complex enterprise database production issues.
Strong understanding of database specifications and data-processing requirements.
Knowledge of ESRI SDE Geodatabases .
Experience with GIS and spatial database concepts.
Ability to design and manage databases according to enterprise standards.
Ability to accurately estimate database administration and analysis tasks.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent written and verbal communication skills.
Experience with Azure SQL .
Experience with AWS database and SQL technologies.
Experience administering ArcGIS Server .
Experience with GIS and spatial databases.
Cloud database administration experience.
Database modernization and migration experience.
Experience supporting large-scale enterprise production databases.
Proven experience administering enterprise SQL Server and Oracle environments.
Strong knowledge of relational database design principles and best practices.
Ability to work independently on complex production database issues.
Strong planning, prioritization, and organizational skills.
Ability to mentor and provide technical guidance to other team members.
Excellent customer service and stakeholder collaboration skills.
Strong decision-making and critical-thinking abilities.
Ability to work effectively with technical and non-technical teams.
Bachelor\'s degree in Computer Science, Information Systems, Information Technology, Database Management, or a related field preferred.
Equivalent professional experience may be considered.
Microsoft SQL Server / Azure Database Certification Preferred
Oracle Database Administrator Certification (OCP) Preferred
Microsoft Certified: Azure Database Administrator Associate Preferred
AWS Certified Database Specialty Preferred
Esri Technical Certification Preferred
...generation of AI products. We build the infrastructure, tools, and model access that teams need to move from idea to production, and do... ...WHAT THIS ISN'T - A launch-comms or copywriter role. - A pure writing role. If you don't want to build, this will frustrate you.
...impact in school and in life. Sylvan Learning provides academic tutoring for students from Pre-Kindergarten through 12th grade, so that students... ...is seeking enthusiastic and dedicated, Certified Reading and Math Tutors to join our team. If you're passionate about education...
...days or weeks at a time? Do you wish you could have a successful trucking career while also maintaining a consistent life at home? Drive... ..., you will be responsible for transporting orders to local customer jobsites in a safe and timely manner using our well-maintained...
...Founding Marketing Manager Nonprofit Technology EveryProspect EveryProspect is seeking a hands-on Founding Marketing Manager to build the marketing foundation for a growing technology and data company serving the nonprofit and fundraising sector. This role...
...We're Hiring: Romanian Onsite Interpreter (Freelance) Toronto, ON Big Language Solutions is looking for an experienced Romanian Interpreter for upcoming onsite CAST appointments in Toronto, Ontario . Position Details: Location: Toronto, ON...