Live chat
WESCO International, Inc.

Senior Database Administrator

WESCO International, Inc. - Pittsburgh, PA

Responsible for designing and creating relational database objects such as tables, views and indexes. Provide continuous support for the production databases. Maintain the environment a relational database requires to function properly. Assist the developers in ensuring the relational database access code performs efficiently. Mentor and manage projects for the Database Administration team.\u003Cbr /\u003E
\u003Cbr /\u003E
Detailed Description\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Train and mentor other DBA team members on all aspects of the DBA role.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Define projects for other DBA team members.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Provide project oversight to DBA projects.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Enforce IT database standards, guidelines and operational policies and procedures.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Review physical database structures.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Review performance, maintenance and utilities associated with each structure (i.e., reorganizations, loads and unloads).\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Review routine backup and export logs.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Review SQL performance and implement tuning as needed.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Review application's access to the database structures.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Routinely test backup and recovery strategies.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Review, where required, the purge/archive criteria for historical data.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Monitor and correct database performance issues.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Develop, test and implement database migration plans.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Perform database software patches and upgrades.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Perform routine monitoring and tuning of databases to insure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention).\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Create instances and databases with appropriate initialization parameters and database structures (to include initial documentation of databases).\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Insure appropriate users are in place with the appropriate security levels.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Evaluate and test new database features/functionality.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Perform database maintenance functions.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Move, rebuild, or change database objects as required in production.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Start and stop database instances.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Provide assistance in the development of the conceptual and logical database design.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Participate in database migration reviews.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Assist developers in functional prototyping, application performance tuning and testing.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Recommend/develop backup/recovery procedures for application tables/indexes.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Provide technical assistance to other team members.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Provide input to the capacity planning function.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Provide ongoing database support in the production environment.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Review daily regulatory change reports (i.e. SOX change changes).Job Requirements\u003Cbr /\u003E
\u003Cbr /\u003E
EXPERIENCE:\u003Cbr /\u003E
7 Years of database administration experience required.\u003Cbr /\u003E
\u003Cbr /\u003E
EDUCATION:\u003Cbr /\u003E
Bachelors\u2019 Degree in Information Systems or equivalent required, Masters' Degree preferred.\u003Cbr /\u003E
\u003Cbr /\u003E
SKILLS/REQUIREMENTS:\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Database Administration.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Knowledge of SQL development and tuning.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Excellent knowledge of database administration, programming and systems analysis procedures.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Current knowledge of database software and operating systems.\u003Cbr /\u003E
\u003Cbr /\u003E
*\u003Cbr /\u003E
Excellent communications, writing and editing skills needed to transfer information to individuals involved in development process.,datePosted:2018-05-03,employmentType:FULL_TIME,industry:Information Technology,hiringOrganization:{@type:Organization,name:WESCO},identifier:{@type:PropertyValue,name:WESCO,value:IRC192141},jobLocation:{@type:Place,address:{@type:PostalAddress,addressCountry:US,streetAddress:,addressLocality:Pittsburgh,addressRegion:PA,postalCode:15219}}}

16 days

WESCO International, Inc.

apply

Senior Database Administrator WESCO International, Inc. - Pittsburgh, PA, United States

   

Location: Pittsburgh, PA

Company Profile:
WESCO International, Inc. (NYSE: WCC), a publicly traded Fortune 500 holding company headquartered in Pittsburgh, Pennsylvania, is a leading provider of electrical, industrial, and communications maintenance, repair and operating ("MRO") and original equipment manufacturers ("OEM") product, construction materials, and advanced supply chain management and logistic services. 2012 annual sales were approximately $6.6 billion. The Company employs approximately 9,000 people, maintains relationships with over 18,000 suppliers, and serves over 65,000 active customers worldwide. Customers include commercial and industrial businesses, contractors, government agencies, institutions, telecommunications providers and utilities. WESCO operates nine fully automated distribution centers and approximately 475 full-service branches in North America and international markets, providing a local presence for customers and a global network to serve multi-location businesses and multi-national corporations.