At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
Description:
Essential Duties and Responsibilities:
• Develop database requirements by reviewing business requirements; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
• Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
• Install revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
• Manages database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
• Manage production, QA, and development database environments.
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Design and implement high availability database infrastructures utilizing failover clustering, SAN replication, and other high availability technologies.
• Prepares users by conducting training; providing information; resolving problems.
• Provides information by answering questions and requests.
• Supports database functions by designing and coding utilities.
• Maintains quality service by establishing and enforcing organization standards.
• Design and manage ETL process for data conversions and data exchange between systems.
• Contributes to team effort by accomplishing related results as needed.
• Conform with and abide by all regulations, policies, work procedures, safety rules and regulations and instructions.
• Respond promptly when returning telephone calls and replying to correspondence and E-mail.
• Provide high quality customer service to all internal and external customers.
• Assist developers with writing effective queries and performance tuning.
Knowledge, Skills and Abilities Required:
• Possess training in relational database administration, and implementation using SQL Server.
• Knowledge of Linux and Windows Systems administration.
• Must have good interpersonal skills.
• Requires advanced problem-solving abilities.
• Knowledge of SQL Server Integration Services (SSIS).
• Knowledge of ETL processes.
• Knowledge of Linux shell scripting and\or Windows PowerShell a plus.
• Experience with Microsoft Visual Studio a plus.
• Experience with Microsoft DevOps (TFS) a plus.
• Experience with Database monitoring tools and backup software
Skills:
Database administrator, Sql, Sql server, Performance tuning
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.