Senior SQL Server Database Administrator DBA (With Informatica)

Job Title: SQL Server Database Administrator DBA (With Informatica) - Remote

Job Description:

We are seeking a highly skilled SQL Server Database Administrator (DBA) with a strong background in ETL (Extract, Transform, Load) processes, particularly using Informatica, to join our team. This is a remote position, offering the opportunity to work from anywhere while contributing to the success of our organization. Experience supporting Aurora in AWS Cloud environment is a plus

Responsibilities:

• Administration: Perform day-to-day management and administration of SQL Server databases, including installation, configuration, maintenance, monitoring, backup, and recovery.
• Tuning: Monitor and optimize database performance, identifying and resolving bottlenecks, inefficiencies, and performance issues. Implement best practices for query optimization, indexing, and resource utilization.
• Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or similar ETL tools. Extract data from various sources, transform it according to business requirements, and load it into target databases or data warehouses.
• Modeling: Design and implement database schemas, data models, and data structures to support ETL processes and business intelligence initiatives. Ensure data integrity, consistency, and efficiency across the database environment.
• Integration: Integrate ETL processes with other systems, applications, and data sources, ensuring seamless data flow and synchronization. Collaborate with cross-functional teams to implement data integration solutions that meet business requirements.
• Develop and maintain automated processes for scheduling, monitoring, and managing ETL jobs, ensuring reliability, scalability, and efficiency. Implement alerting and notification mechanisms for proactive monitoring and issue resolution.
• Create and maintain comprehensive documentation for database configurations, ETL workflows, data mappings, and technical specifications. Ensure that documentation is accurate, up-to-date, and accessible to relevant stakeholders.
• and Compliance: Implement and enforce security measures, access controls, and data encryption standards to protect sensitive data stored in databases. Ensure compliance with industry regulations, data privacy laws, and company policies.
• and Support: Provide technical support and troubleshooting assistance for database-related issues, ETL failures, and data discrepancies. Work with development teams and business users to resolve issues in a timely manner.

• degree in Computer Science, Information Technology, or related field.
• experience as a SQL Server Database Administrator (DBA) with expertise in performance tuning and optimization.
• proficiency in SQL programming, database design, and data modeling concepts.
• experience with ETL tools such as Informatica PowerCenter, SSIS (SQL Server Integration Services), or similar platforms.
• in designing, developing, and maintaining ETL processes for data integration and transformation.