Note: The job is a remote job and is open to candidates in USA. SMX Services & Consulting, Inc. provides technology, consulting, and professional services to commercial and government customers. The company is seeking a Senior Consultant to provide technical leadership, architecture guidance, administration, troubleshooting, governance, mentoring, and knowledge transfer for SAP IQ database and SAP Data Services environments supporting the IRS Compliance Data Warehouse.
Responsibilities
- 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
Skills
- 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
- Must be a U.S. Citizen
- Must be able to successfully complete applicable IRS personnel security and suitability requirements
- Must be able to satisfy federal tax-compliance screening requirements
- Must satisfy Selective Service registration requirements, if applicable
- Must successfully complete required fingerprinting and background investigation processes
- Must complete required IRS security forms and Non-Disclosure Agreements
- Must complete required IRS security, privacy, records management, and role-based training
- Must be eligible to receive and maintain applicable IRS Personal Identity Verification (PIV) credentials and staff-like access
- Extensive hands-on SAP IQ administration experience
- SAP IQ certification
- Prior U.S. Federal Government experience
- Prior IRS or Department of the Treasury experience
- Experience supporting medium-security federal information systems
- Experience with SAP Data Services
- Large-scale enterprise data warehouse experience
- Experience with mission-critical production systems
- Experience with SAN-connected database environments
- Strong ETL architecture and operational support experience
- Experience supporting distributed Linux and Windows environments
- Experience collaborating across Government and multi-contractor teams
Benefits
- Primarily remote work arrangement
- Government-furnished laptop/desktop equipment and PIV credentials are expected to be provided for assigned personnel
Company Overview