Database Administrator

Database AdministratorInterSources Inc, a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries. Our history spans over 16 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud partner company.Job Responsibilities:Experience with planning, documenting and performing upgrades and migration, setting up new database environments.Develop moderate/complex SQL statement for data migration (ETL process).Support Application Developers in designing, implementing and testing database changes to support business applications.Assist Application Developers code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes.Design and plan upgrade strategies including coordination with system administrators and developer. Upgrade plans must include checklist, milestones, complete checkout, and exercised fallback proceduresAssist other Database Administrators maintain multiple DB2 LUW environments, such as Development, QA, Training and Production.Support Database Administrators and Systems Administrators during patching of operating systems and database systems.Document entity types and the relationships between entities with an Entity Relationship Diagram using Erwin.Ability to work during non-business hours including weekends and holidays, as needed.Qualifications:Five years' experience as a Database Administrator.Five years' experience with Structure Query Language (SQL).Three years' experience as a Database Administrator on DB2 LUW.Three years' experience with Red Hat's Enterprise Linux (RHEL).One year experience with Relational Data Modeling.One year experience with Microsoft's Outlook, EXCEL and WORD.One year experience with Erwin.Preferred Qualifications:Experience with Quest's Toad for DB2 LUW,IBM's Data Quant or QMF.Experience with moderate/complex SQL developmentExperience with Unix shell scripts, such as ksh, csh, bash or sh.Experience with COBOL.Experience with DBI Software's Performance Suite for DB2 LUW.Experience with SQL Server, MySQL or TeradataExperience with Local, State or Federal government.Personal Qualities:Be innovative, energetic, energizing, flexible and eager to learn. Excellent work ethic, attention to detail, ability to work in a highly collaborative, collegial, multidisciplinary fast paced team environment. Excellent analytical skills with the ability to manage multiple priorities and requests. Excellent communication and interpersonal skills. Ability to work independently and meet requested deadlines promptly.Skills:Experience as a Database AdministratorExperience with Structure Query Language (SQL).Experience as a Database Administrator on DB2 LUW.experience with Red Hat's Enterprise Linux (RHEL).Experience with Relational Data ModelingExperience with Microsoft's Outlook, EXCEL and WORD.Experience with ErwinExperience with Quest's Toad for DB2 LUW,IBM's DataQuant or QMF.Experience with moderate/complex SQL developmentExperience with COBOLExperience with Local, State or Federal government