Senior Consultant – SAP IQ Database Support

Senior Consultant – Sap Iq Database Support

Smx Services & Consulting, Inc. is seeking a highly experienced Senior Consultant – Sap Iq Database Support to support the Internal Revenue Service Compliance Data Warehouse environment.

The selected candidate will provide senior-level technical leadership, architecture guidance, operational support, troubleshooting, governance, mentoring, and knowledge transfer across Sap Iq database and data integration environments.

The Irs Compliance Data Warehouse supports more than 5,000 advanced users and manages approximately 10 petabytes of structured and semi-structured data from more than 70 source systems. The environment includes Sap Iq, Sap Data Services, Red Hat Enterprise Linux, Windows, San-connected storage, remote mount points, file shares, and direct-attached storage.

The Senior Consultant will:

• Lead the design, implementation, enhancement, and operational support of complex enterprise database and data integration solutions.
• Provide technical leadership for Sap Iq database administration and Sap Data Services environments.
• Support Sap Iq Simplex and Multiplex database environments.
• Monitor database access, performance, utilization, reliability, and capacity.
• Support database backup and recovery operations.
• Maintain and oversee database accounts, privileges, and access controls.
• Recommend database architecture, design, and performance improvements.
• Plan, test, and support deployment of software patches, version upgrades, configuration changes, and cybersecurity Cve mitigations.
• Lead SQL performance tuning and query optimization efforts.
• Recommend indexing, partitioning, schema, and server configuration improvements.
• Support logical and physical data modeling.
• Provide technical leadership for Etl architecture, development, testing, deployment, monitoring, and support.
• Guide data ingestion and transformation processes involving structured databases, flat files, Xml, text, and other supported formats.
• Support Etl error handling, logging, monitoring, reconciliation, restart, and recovery processes.
• Troubleshoot complex database, Etl, integration, and performance issues.
• Perform root-cause analysis and recommend corrective and preventive actions.
• Support technical cases with Sap Technical Support.
• Establish and enforce technical standards, governance practices, operational procedures, and documentation.
• Mentor database administrators, developers, analysts, and technical staff.
• Provide knowledge transfer and training to technical and non-technical stakeholders.
• Support development and maintenance of technical plans, standard operating procedures, quality documentation, status reports, and project deliverables.
• Collaborate with Government personnel, other contractors, infrastructure teams, application teams, and service providers.
• Support periodic after-hours and weekend maintenance activities as required.

These responsibilities align with Pws requirements for Data Management, Sap Data Services Administration, Technical Support, and Transition Support.

Candidates must have:

• Minimum of fifteen (15) years of progressively responsible experience supporting enterprise database environments.
• Demonstrated ability to lead the design, implementation, enhancement, and operational support of complex database and data integration solutions.
• Proven experience providing technical leadership, mentoring, training, and knowledge transfer.
• Experience developing and enforcing technical standards, operational procedures, governance practices, and technical documentation.
• Strong analytical, troubleshooting, problem-solving, and decision-making skills.
• Excellent written and verbal communication skills.
• Ability to communicate effectively with technical teams, management, Government personnel, and business stakeholders.

Strong experience in several of the following areas is required or highly desirable:

• Sap Iq database administration
• Sap Data Services
• Enterprise data warehouse operations
• Sap Iq Simplex and Multiplex environments
• Sql development and optimization
• Complex sql query analysis
• Database performance tuning
• Schema and…