Maryland Staffing
Informatica Database Administrator
Maryland Staffing, Annapolis, Maryland, United States, 21403
Informatica Administrator
The Informatica Administrator is responsible for the installation, configuration, monitoring, maintenance, and optimization of Informatica software tools used for data and application integration, transformation, and management. This role involves troubleshooting issues, ensuring performance, and maintaining data workflows to support business intelligence and analytics. Responsibilities include: installing and configuring Informatica PowerCenter, Informatica Cloud Data Integration, and related components; configuring and maintaining repository, domain, and services on the Informatica server; setting up environment-specific configurations for Informatica services; developing remediation steps for Common Vulnerabilities and Exposures identified by the security team; monitoring and fine-tuning the performance of Informatica jobs and workflows; optimizing the performance of the Informatica server; identifying, troubleshooting, and resolving issues related to Informatica sessions, workflows, and connectivity; resolving system-level issues affecting Informatica services and tools; performing regular system monitoring and ensuring the health and availability of the Informatica environment; setting up automated alerts for job failures, service downtimes, or performance issues; evaluating new features and capabilities of Informatica products; staying current with industry trends in data integration, cloud computing, and ETL technologies; implementing and managing backup and disaster recovery procedures for Informatica repositories and configurations; working closely with data engineers, developers, and other IT teams to support data integration requirements; providing support for troubleshooting and resolving technical issues related to the Informatica platform; maintaining accurate documentation for system configurations, procedures, and workflows; generating reports on system performance, resource utilization, and other metrics; collaborating with data architects to design efficient, scalable cloud-based data integration architectures using IICS; evaluating and optimizing current PowerCenter architectures for migration feasibility; and aligning migration strategies with the organization's cloud adoption, data governance, and security policies. Minimum Qualifications: Bachelor's Degree required or equivalent relevant experience. Master's Degree Preferred. 12+ years of experience working with progressively more complex or large-scale databases. Other Job Specific Skills: Strong experience supporting Informatica PowerCenter, IICS, and other Informatica products. Hands-on experience with database management systems such as Oracle, SQL Server, or PostgreSQL. Hands-on experience with Informatica Connectors such as MySQL, PostgreSQL, JNDI, JMS, PowerExchange, S3, S3 Delta, or Amazon RedShift. Experience managing Oracle RAC and Data Guard databases. Knowledge of UNIX/Linux commands and shell scripting. Experience with system monitoring tools and techniques. Proficiency in troubleshooting and resolving Informatica issues. Excellent communication and collaboration skills. Preferred Skills: Informatica certification (e.g., Informatica PowerCenter Administrator). Experience with cloud-based data integration tools e.g., Informatica Intelligent Cloud Services (IICS). Familiarity with ETL processes and data warehousing concepts. Hands-on experience with Oracle DBA functions in an enterprise environment. Compensation ranges for ASM Research positions vary depending on multiple factors including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees. EEO Requirements: It is the policy of ASM that an individual's race, color, religion, sex, disability, age, gender identity, veteran status, sexual orientation, or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies. All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, veteran status, disability, gender identity, or age. All decisions on employment are made to abide by the principle of equal employment.
The Informatica Administrator is responsible for the installation, configuration, monitoring, maintenance, and optimization of Informatica software tools used for data and application integration, transformation, and management. This role involves troubleshooting issues, ensuring performance, and maintaining data workflows to support business intelligence and analytics. Responsibilities include: installing and configuring Informatica PowerCenter, Informatica Cloud Data Integration, and related components; configuring and maintaining repository, domain, and services on the Informatica server; setting up environment-specific configurations for Informatica services; developing remediation steps for Common Vulnerabilities and Exposures identified by the security team; monitoring and fine-tuning the performance of Informatica jobs and workflows; optimizing the performance of the Informatica server; identifying, troubleshooting, and resolving issues related to Informatica sessions, workflows, and connectivity; resolving system-level issues affecting Informatica services and tools; performing regular system monitoring and ensuring the health and availability of the Informatica environment; setting up automated alerts for job failures, service downtimes, or performance issues; evaluating new features and capabilities of Informatica products; staying current with industry trends in data integration, cloud computing, and ETL technologies; implementing and managing backup and disaster recovery procedures for Informatica repositories and configurations; working closely with data engineers, developers, and other IT teams to support data integration requirements; providing support for troubleshooting and resolving technical issues related to the Informatica platform; maintaining accurate documentation for system configurations, procedures, and workflows; generating reports on system performance, resource utilization, and other metrics; collaborating with data architects to design efficient, scalable cloud-based data integration architectures using IICS; evaluating and optimizing current PowerCenter architectures for migration feasibility; and aligning migration strategies with the organization's cloud adoption, data governance, and security policies. Minimum Qualifications: Bachelor's Degree required or equivalent relevant experience. Master's Degree Preferred. 12+ years of experience working with progressively more complex or large-scale databases. Other Job Specific Skills: Strong experience supporting Informatica PowerCenter, IICS, and other Informatica products. Hands-on experience with database management systems such as Oracle, SQL Server, or PostgreSQL. Hands-on experience with Informatica Connectors such as MySQL, PostgreSQL, JNDI, JMS, PowerExchange, S3, S3 Delta, or Amazon RedShift. Experience managing Oracle RAC and Data Guard databases. Knowledge of UNIX/Linux commands and shell scripting. Experience with system monitoring tools and techniques. Proficiency in troubleshooting and resolving Informatica issues. Excellent communication and collaboration skills. Preferred Skills: Informatica certification (e.g., Informatica PowerCenter Administrator). Experience with cloud-based data integration tools e.g., Informatica Intelligent Cloud Services (IICS). Familiarity with ETL processes and data warehousing concepts. Hands-on experience with Oracle DBA functions in an enterprise environment. Compensation ranges for ASM Research positions vary depending on multiple factors including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees. EEO Requirements: It is the policy of ASM that an individual's race, color, religion, sex, disability, age, gender identity, veteran status, sexual orientation, or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies. All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, veteran status, disability, gender identity, or age. All decisions on employment are made to abide by the principle of equal employment.