US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 23rd Nov 2023
• Using DBMS(s) currently employed by the MSLC, create and maintain databases accessed by all MSLC users.
• Monitor MSLC databases and proactively perform modifications, optimization adjustments, updates and upgrades as necessary.
• Recommend modifications and solutions regarding databases, security, backup and recovery and schedules.
• Update, modify, reconfigure, backup and restore systems and servers.
• Experience with database performance optimization.
• IBM DB2 and IBM InfoSphere suite experience
• Solid understanding of SQL and experience working with DB2 relational databases.
• Familiarity with RedHat Linux operating systems
• Work with MSLC users and programming personnel to identify application and technical requirements, evaluate existing systems and propose/design database solutions.
• Familiarity with data warehousing concepts and methodologies.
• Strong problem-solving skills and the ability to analyze complex data integration challenges.
• Excellent communication skills to collaborate effectively with cross-functional teams.
• Design, develop, test, and maintain ETL processes to ensure the accurate and efficient movement of data from various sources into our data warehouse.
• Collaborate with data engineers, data analysts, and other stakeholders to gather requirements and ensure the ETL processes align with business needs.
• Optimize and fine-tune ETL workflows for performance and scalability, identifying and resolving bottlenecks and inefficiencies.
• Monitor ETL jobs, troubleshoot and resolve data integration issues in a timely manner.
• Ensure data quality and integrity through validation and cleansing processes.
• Stay current with industry trends and best practices in ETL development and data integration.
• Knowledge of IT Best Practices for maintaining patch management, documentation, and archiving protocols.
• Advanced ability to use OS utilities.
• Perform additional duties and responsibilities as assigned.
• Bachelor’s degree in computer science or equivalent work experience
• Associate Degree or Relevant Experience Required
• Analytic and logical problem-solving skills
• Experience in administration of multiple IBM DB2 databases
• Knowledge of Linux and Windows operating systems, with demonstrated ability to navigate in each and to write simple scripts and reports
• Working knowledge of report writing software (e.g. SAP BO, Tableau)
• Ability to use standard Microsoft software (Excel, Word, Outlook, Sharepoint)
• Experience with cloud platforms such as AWS, Azure, or Google Cloud is a plus