TekSynap ยท 10 hours ago
Mid Microsoft SQL Server Database Expert
TekSynap is a fast growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment. We are seeking an Oracle Subject Matter Expert (SME) to provide advanced technical leadership, deep Oracle expertise, and advisory support for enterprise and mission-critical database environments at the U.S. Census Bureau.
ComputerInformation ServicesInformation Technology
Responsibilities
Serves as the technical authority and subject matter expert for Oracle database technologies across the enterprise
Provides expert-level Oracle database administration support for large, complex, multi-tiered production environments
Performs advanced installation, configuration, upgrade, patching, monitoring, and maintenance of Oracle databases (11.x, 12.x, and higher)
Provides 24x7 production and on-call troubleshooting support, including complex issue resolution and root cause analysis
Designs, develops, and optimizes advanced database objects using Oracle SQL and PL/SQL, including packages, procedures, functions, views, cursors, and complex business logic
Leads database performance tuning and optimization efforts, including partitioning, indexing, compression, and query optimization
Provides expertise in storage management using Oracle Automatic Storage Management (ASM) and supports Oracle Real Application Clusters (RAC) configurations
Supports spatial data management and analysis using Oracle Spatial and Graph, including development of physical, network, and social graph data models
Advises program teams and stakeholders on Oracle architecture, design decisions, scalability, and best practices
Works directly with onsite and offsite customers to gather requirements, analyze needs, and develop effective database solutions
Troubleshoots Oracle product issues and provides expert guidance for problem resolution and corrective actions
Supports Oracle database environments operating on Linux and UNIX-based operating systems, including Sun Solaris and Red Hat Linux
Develops and maintains technical documentation, standards, and best practices in alignment with DCoE policies
Works independently while mentoring junior and mid-level database administrators
Qualification
Required
Five (5) or more years of hands-on experience as an Oracle Database Administrator supporting enterprise and production database environments
Experience must include Oracle database administration (11g, 12c, or higher), advanced SQL and PL/SQL development, performance tuning, troubleshooting, and operational support in a multi-tiered environment
The individual must demonstrate expert-level Oracle knowledge and the ability to provide technical leadership and independent problem resolution
A Bachelor's Degree in Computer Science or a related technical field is required
Fifteen (15) years of applicable experience may be substituted for degree requirements
Must possess at least one Oracle database certification relevant to the scope of this effort
Preferred
Minimum five (5) years of experience performing Oracle database administration duties, specializing in Oracle and SQL
Extensive experience with Oracle SQL and PL/SQL, including development of complex queries and advanced database objects
Deep expertise in Oracle performance tuning, partitioning, indexing, and compression
Hands-on experience supporting large-scale, mission-critical production databases in a multi-tiered environment
Experience with Oracle product troubleshooting and advanced problem resolution
Experience configuring and administering Oracle databases (12c or higher) on Linux platforms
Experience with operating systems including Sun Solaris 10.0 or later and Red Hat Linux 6.x or later
Strong ability to work independently and provide technical leadership
Strong oral and written communication skills
Benefits
Health
Dental
Vision
401K
Life insurance
Short-term and long-term disability plans
Vacation time
Holidays
Company
TekSynap
TekSynap is a well planned information management environment that offers to meet the business needs of Local Government customers.
Funding
Current Stage
Late StageRecent News
Washington Technology
2025-12-12
citybiz
2025-11-19
2025-11-18
Company data provided by crunchbase