Posted 2 years ago in Information Technology
Lionce is currently recruiting for a Junior SQL DBA/ERP Systems Administrator for a great opportunity with one of our partners in Pittsburgh, PA. This is a full time position with a pay rate up to $65,000 a year. For this particular role, our client is only considering either US Citizens or Permanent Residents (either EAD or Green Card).
The Junior DBA will support senior staff with administration, maintenance and security of our ERP system. They will maintain infrastructure, data integrity, operating stability and efficiency. They will provide user training and support as necessary. Periodically produce business reports, generate output for forms, charts, data files and respond to frequent management requests for information. This position requires extensive knowledge of Crystal Reports, word processing, spreadsheet applications and working knowledge of database programs that support ERP applications. They will engage in personal, professional development to stay current with the demands of the position.
-The Primary focus includes assisting of administration, development and support of database environments and applications.
-Assist Sr. DBA with daily administration of the ERP system.
-Assist Sr. DBA with administration of the MS SQL 2000, 2005 and 2008 database servers, including monitoring performance, availability, capacity, and backup.
-Test for and help correct errors recommending changes to systems. Ensure that critical process and data feeds have completed on a daily basis.
-Assist Sr. DBA with service and application upgrades.
-Maintain and perform minor development of web based database applications.
-Write SSIS (SQL Server Integration Services) ETL packages for data migration or custom reports.
-Develop, implement and distribute Crystal Reports for the user community.
-Provide end user support and training for both in house and remote users.
-Train and empower the user community to be self-supportive in mining data to generate reports.
-Bring new ideas and methodologies to improve the department.
-All other duties as assigned
Required Skills, Attributes & Education:
-At least 2 years of experience in Database Administration within a manufacturing environment
-MCDBA desired on SQL 2005 or above
-Requires extensive knowledge of Crystal Reports, MS Excel and MS Word
-Extensive knowledge of database applications with excellent problem-solving skills
-Knowledge of Microsoft Windows Server as related to all versions of SQL services, MRP and ERP applications
-Experience with remote access technology, terminal services, remote app, network connectivity and the associated issues as they relate to database connectivity
-Ability to work independently, multitask, handle interruptions, and prioritize workloads
-Positive attitude and strong professional work ethic
-BA/BS in Information Systems or Microsoft DBA certificate in addition to experience
-M2M ERP experience a plus, ERP system with SQL backend a plus
-Experience with Sarbanes-Oxley compliance
Browse sql dba jobs in Pittsburgh, Pennsylvania: