Database Administrator/Developer - 91009QVD
Job Description


LAST UPDATED: Jul 7, 2014






Basic Function



This non-exempt position as MS SQL DBA will administer and optimize existing databases, and design and develop new database systems while working closely with a team of software engineers and system administrators. This individual will provide support, optimizations, and automation for series of external data feeds and internal relationships.



While this position primarily supports existing accounting and DM systems, it also directly supports the software development process, and it also includes rotating on-call assignments for top-tier production support and ongoing maintenance and reporting on existing systems.





Essential Duties



• Create new SQL language elements to include use of Common Table Expression's,

   Apply/Cross Apply operators, logical and physical partitioning of data. (Knowledge will

   be tested with current production code). Solid understanding of set-based-solutions.

• Database monitoring and tuning, including SQL Profiler, Windows System monitor,

   indexing strategies and query/index tuning.

• Balance the needs of multiple projects and tasks simultaneously.

• Interact with large mission-critical application databases.

• Assist in performance monitoring, query tuning, and capacity planning

• Assist development team with debugging and optimization of SQL queries and stored

   procedures.





Other Duties



• Will include table partition, replication, Microsoft SQL Clustering, and database

   backup recovery automation

• Performs other related duties as needed or assigned.





Reporting Relationship



This position reports directly to the Manager of Infrastructure and Security.



Subordinate Staff: N/A





Desired Education



Bachelor’s Degree or certification





Qualifications



Knowledge/Experience: 5+ years’ experience designing and implementing database systems, including 3+ years’ experience designing and implementing SQL Server database systems using SQL Server 2005/2008 required (Microsoft Certified Professional Database Developer preferred).



• Ability to share product specific technical knowledge with peer developers.

• Experience with stored procedures, triggers, SQL scripts, and performance issues with

   client/server database design and Data Access Layer design, including browser based

   applications.

• Knowledgeable in the use of metadata for code generation and code that writes code

   (highly desirable). • Experience with high-volume databases, index management,

   physical database design, and server configuration settings.

• Knowledge in utilizing relational data modeling principles and techniques.

• Ability to share product specific technical knowledge with peer developers



Skills:

• Ability to communicate effectively and professionally with coworkers, peers, and

   management through written and verbal communication.

• Ability to communicate with customers, internal departments, and other outside

   parties who prefer different communication styles in a professional manner.

• Effectively communicate with developers and quality assurance staff in the resolution

   of technical problems.

• Strong TSQL and SSIS skills.

 

Education: Bachelor’s Degree or certification and equivalent work experience.





Physical Demands and Working Conditions



Physical Demands: Possible server transport and setup. Must be able to move up to 70 lbs and perform hardware maintenance (rack mounting, cabling, networking, server setup) when requested by management. This position requires constant communication and exchange of information with the Firm attorneys, clients and staff; this position must be able to inspect and observe information on a computer screen at least 80% of the time.



Working Conditions: Office Environment. Some possible offsite projects. Overtime, weekends and occasional travel possible but very rare. Occasional off-hours (evenings and weekends) requests and troubleshooting possible.







(Salary Depends on Experience)


Job Requirements

Language Requirements: English

Company Overview

As one of the world’s leading staffing companies, our primary objective is clear-cut: To perfectly align the best people with appropriate positions for our clients everywhere. Every day, we talk to hiring managers, HR directors, procurement managers, and senior management to learn their needs. At the same time, we’re bringing in candidates and associates with a variety of skills and backgrounds, seeing how we can best put their skills to use.
Advantage Resourcing Americas, Inc. is an equal employment employer and is committed to providing employment opportunities to minorities, females, veterans, and disabled individuals.


  • Apply Now
  • Database Administrator/Developer - 91009QVD @ Advantage Resourcing

Almost there!

Submit your email address to begin the application process for the Database Administrator/Developer - 91009QVD job. .

Email is invalid Email address is needed

By applying to a job using CareerBuilder.com you are agreeing to comply with and be subject to the CareerBuilder.com Terms and Conditions for use of our website.