About Core & Main
Core & Main (www.coreandmain.com) is one of North America’s largest distributors of water, sewer, storm, fusible piping and fire protection infrastructure products that serves the needs of both contractors and municipalities in all aspects of the water, wastewater, clean water, landfill, energy, and fire protection industries. Core & Main operates more than 246 branches serving North America, the Caribbean and international markets. The company provides localized, customer-driven services including jobsite delivery, will call or direct-ship options, diversified logistics and innovative solutions that contribute to its customers' success.
Job Description & Qualifications
Design, implement and maintain databases and oversee performance. Analyze table storage parameters and file system layout and size to ensure maximum performance. Develop utilities and programs to assist with task automation, data manipulation and integration. Monitor automated tasks.
Major Tasks, Responsibilities and Key Accountabilities
Partners with Sr. DBA's to create physical database structures for small projects based on physical design for development, test, and production environments.
Performs routine maintenance, including upgrades and patches. Resolves issues via service tickets. Performs daily data back-up and recovery as needed. Generates scheduled and ad hoc reports.
Partners with Sr. DBA's and engineers to configure servers for DBMS product installation and small database creation.
Provides on-call support for assigned databases 24/7 to include investigating and troubleshooting problems.
Configures and maintains DBMS product software on small database and application servers.
Manages conversions of data from legacy/acquired systems as required. Reports escalated issues to Sr. DBA.
Monitors and adjusts database parameters for better performance.
Assists application teams with tuning of SQL statements.
Nature and Scope
Demonstrates skill in data analysis techniques by resolving missing/incomplete information and inconsistencies/anomalies in more complex research/data.
Nature of work requires increasing independence; receives guidance only on unusual, complex problems or issues. Work review typically involves periodic review of output by a supervisor and/or direct "customers" of the process.
May provide general guidance/direction to or train junior level support personnel or professional personnel.
Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
Typically requires overnight travel less than 10% of the time.
Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.
Must be eighteen years of age
Must pass the Drug Test
Must pass the Background Check
Must pass pre-employment tests if applicable
Education and Experience
Typically requires BS/BA in a related discipline. Generally 2-5 years of experience in a related field; certification is required in some areas OR MS/MA and generally 2-4 years of experience in a related field. Certification is required in some areas.
Preferred Qualifications & Job Specific Details
Database management experience with 1000+ concurrent users.
Programming experience at database level specifically with Oracle, SQL Server, Universe, and Unidata strongly preferred.
Experience with database internals, Oracle 9i, Oracle 10-G, Oracle RAC, and DB2 Teradata preferred.
Familiarity with networking.