Seeking a talented individual with experience as a senior SQL DBA and architect for a 24x7 manufacturing environment. The incumbent will have experience with high availability, clustered, and high transaction processing SQL servers. An understanding of .Net software architecture is desired. Architecture experience is also required for this senior role. This individual needs to have strong communication skills and project management experience.
Responsible for meeting with customers, determining requirements, communicating the requirements to the internal architectural team and managing the overall implementation to make sure all groups are working toward a single goal. Strategic thinker with a clear understanding of the desired end-state while being able to delegate specific tasks to the appropriate team.
Excellent at problem solving, incident analysis and bringing in various groups in an effort to coordinate joint troubleshooting efforts.
Work closely with developers and database team members to design, develop and enhance Microsoft SQL Server 2005/2008 database solutions.
Work with developers and business users to define requirements, perform analysis and design, and implement robust, maintainable solutions that meet the business requirements.
Lead and participate in reviews and quality assurance processes to ensure that the data architectures and standards are being adhered to. Enforce policies and procedures to team members.
Create and maintain conceptual, logical, and physical database models.
Create SSIS packages to import/export data, and load and process data.
Develop and enhance stored procedures. Write ad-hoc SQL queries to support report requests.
Design and develop meaningful business reports (BI), either web based or thick client.
Preparing data for job runs and supporting jobs in process.
Troubleshooting, analyzing and repairing job issues.
Bachelor's degree from accredited university or equivalent work experience.
Minimum 15 years relevant work experience.
Minimum 6 years experience managing staff in the development of custom application development.
5+ years experience as MS SQL DBA.
Understanding of and experience with different SDLC methodologies.
Must know the build, change, release cycle and understand source code management.
Experience with project management tools and management of projects.
Excellent oral and written communication skills.
Ability to learn quickly in a fast paced environment and be flexible.
Proven management and leadership skills. Prepare time lines for the project completion.
Proven ability to effectively contribute to cross-functional teams.
Strong familiarity with .NET, Ajax, HTML, Web Services, and MS SQL Server.
Experience writing technical specifications for software developers.
Document database structures for an MS SQL Database and software applications.
Software development and software project management; review, test and implement code.
Lead and mentor development staff; directly supervise development team of 5 or more skilled
Work directly in MS SQL database including architecture and DBA functions.
Full-time position which includes being on call 24 hours a day/7 days a week to assist in any software
emergencies. Some weekends and late night/early morning hours will be required as needed.
MS SQL Database development including designing, developing, testing and implementing databases, stored procedures, function, triggers, indexes, jobs.
Background in Object Oriented analysis & design, N-Tier architecture, Stored Procedure, triggers,
SQL queries and SSIS packages.
Kapsis - 13 months ago