Database Administrator - Senior

Company: Schneider Electric ( Learn More )

Apply Now
General Information
US-KY-Louisville
N/A
Not Specified
Full-Time
Not Specified
Not Specified
False
False
Job Description Intro:About Schneider ElectricAs a global specialist in energy management with operations in more than 100 countries, Schneider Electric offers integrated solutions across multiple market segments, including leadership positions in Utilities & Infrastructures, Industries & Machine Manufacturers, Non-residential Buildings, Data Centres & Networks and in Residential. Focused on making energy safe, reliable, efficient, productive and green, the Group's 130,000 plus employees achieved sales of 22.4 billion euros in 2011, through an active commitment to help individuals and organizations make the most of their energy. www.schneider-electric.com Job Responsibilities:Summit Energy, a subsidiary of Schneider Electric is a leading provider of sustainability and energy management services for business and industry. Summit manages more than $20 Billion annually for thousands of facilities in industries ranging from aerospace and automotive to government, chemical, food manufacturing, pharmaceuticals, healthcare and others. Its growing staff of more than 300 energy professionals is headquartered in Louisville, Kentucky. Summit has additional offices in the U.S., as well as Belgium, France, Germany, Mexico and The Netherlands. Summit serves clients with sites all over the globe. For more information, visit www.summitenergy.com.Position Summary:Growing company in an exciting and challenging industry looking for a highly motivated, experienced DBA to plan, build, tune and maintain database technologies interfacing with highly visible business and customer facing technology applications which enhance business operations and contribute to achieving strategic business objectives. STRONG PREFERENCE FOR LOUISVILLE, KY BASED CANDIDATES. Candidates must be eligible to work in the US.Character Requirements:Integrity: being above board in all internal & external relationshipsDecisiveness: has the ability to sort through information and make appropriate and timely decisionsInitiative: recognizes opportunity and action without being asked Diligence: energized by being diligent in meeting deadlines and completing tasks on time.Thoroughness: pays close attention to detail, produces accurate work in a timely fashion and determined to find "Root Cause" when there is a problemResponsibility: understands expectations and follows through in accomplishing themPosition responsibilities:Responsible for all aspects of the DBA role - database design & development, production support and root cause analysis, database administration, performance tuning, replication, data warehousing, backup & recovery.Database Development oConsult with customers and developers to determine needs and databaserequirementsoMapping out the conceptual design for a planned database in outline and refining this design so that it can be translated into a specific data modeloCreate logical design and data model from user specifications for in-house applications and customizations to purchased applicationsoPlanning data-flows for a new or revised databaseoCreate physical design to meet system storage requirements and document new databasesoDevelop store procedures to provide proper application data access and logicoManage Database SSIS code, SP's, change management, and moves between production, test and development environmentsoPerform data conversions and maintain data integrity oUpgrade databases for major applications.oThorough DB testing with appropriate test plans Database Administration & MaintenanceoMicrosoft SQL-Server administration oPowerShell scriptingoResponsible for database server architecture and design as well as server environment recommendations for overall infrastructure solution including disk storage capacity planningoInstall, upgrade, configure business application and database software on Windows & support Microsoft SQL-Server, IIS, .Net and Java J2EEoImplement and maintain schedule for maintenance jobs in order to maintain the health, performance, and integrity of the database systemsoResponsible for availability and reliability of business data stored in production application databases, ensuring integrity of dataoMaintain database and data recoverability, ensuring that storage, archiving, backup and recovery procedures are functioning correctly oResponsible for database alerts, maintenance plans and scriptsoManage database security and control access permissions and privilegesoCommunicating regularly with technical, application development, business, and operational staff, to ensure the security and confidentiality of dataoCommissioning and installing new applicationsoSupport database connectivity using SSIS, replication, linked servers, ODBC, JDBC and OLEDBDatabase support for applications, both in-house development and purchased applications.oResolve production database problems with team members and whenever possible, implement improvements that will prevent reoccurrence of problemsoProvide support & training to development teamoParticipate in the correction of production data issuesoRespond to issues requestsoResolve user access & permissions issuesDocumentation & ProcessesoReview of SP's for performance, logic and conformance to standardsoDevelop and maintain database documentation, including data standards, procedures and definitions for the data dictionary ('metadata')oPerform product evaluation that includes DBMS engines as well as tool sets that support them in the development and production environmentoProvide continued oversight of the build promotion process and control of the production DB environmentEssential skills and qualifications:At least 3 years MS SQL Server 2000/2005/2008 database programming and admin experience Strong skills & experience in performance tuning - Index, Table, queries, SprocsExcellent problem solving skillsExperience with Triggers, Stored Procedures, SQL Server Queries.Experience in the following technologies - replication, data warehousing and scalabilityOpen and accommodating of offshore resources and willingness to mentor and learn from these individualsExperience with establishing and overseeing formal build promotion processes including use of source control and DB source control best practicesAbility to think logically and analyze business process requirements and accurately convert them to DB structure design and logicExcellent oral and written communication skills Ability to effectively multi-task and effectively meet deadlines within a dynamic, fast paced and challenging environmentEffective working on teams, within and outside of functionNon-Essential skills and qualifications:Associates or Bachelor's degree in Computer Science, Information Systems, Business, or related field preferredPowerShell scriptingExperience with Service Broker a plusExperience in object-oriented programmingAdditional skills and experience in Java, J2EE, JBoss, .NET, localization, data warehousing, workflow, document imaging.Programming background in VB.NET, ASP.NET, HTML, XML, Java Script, MS IIS, Microsoft Visual Studio and SVN. Schneider Electric is an equal opportunity employer. Applicants receive consideration for employment without regard to race, color, religion, sex, age, national origin, disability or veteran status.
Job Requirements 
Apply Now