IT DBA - Senior SQL

New York-White Plains-Wayne, NY

Posted: 08/14/2018 Job Category: Database Job Number: 138195

Are you looking for a new and challenging opportunity? Do you have experience with SQL Server DBA? Technology Partners can help you make your next big career move a reality.



Technology Partners is currently seeking a talented person for an IT DBA - Senior SQL position.



What You Will Be Doing:

You will code various ETL and SQL processes. You will create/modify Stored Procedures. You will also handle performance tuning and optimization, including partitioning, indexing schemes, table compression, etc. You will participate in design and analysis sessions with technical leads/Delivery managers to ensure sound team decision-making, and come up with the best appropriate solutions. You will document required changes in Data warehouse and ETL architecture diagrams. You will maintain data integrity with associated audits. You will create data loads. You will also maintain data.



What We Are Looking For:

  • 5+ years of experience as a SQL Server DBA.

  • 3+ years of hands on experience with Stored Procedures and SSIS development in a SQL Server.

  • Experience in developing very large Data Warehouse applications.

  • Experience with complex stored procedures used for ETL, DQ and validation.

  • Experience leveraging SQL Server 2008 - 2014 features such as SDC, partitioning, indexing schemes, table compression, etc.

  • Experience collaborating and standardizing on design and development processes.

  • Experience with conducting data architecture, design and code reviews and providing feedback on database engineering best practices

  • Ability to conduct and provide written RCA (Root Cause Analysis) and directly address root cause by implementing fixes in code or configuration

  • Experience designing and developing high performance database and reporting systems

  • Experience documenting required changes in Data warehouse and ETL architecture diagrams.

  • Excellent oral and written communications skills.

  • BS or MS degree in Computer Science or equivalent work experience.

  • SQL server: 5 years



It Would Be Great, but Not Required, if You Had:

  • NoSQL databases such MongoDB, Cassandra, or others

  • JavaScript, ASP.NET, C#

  • SSAS, SSRS



If this position sounds like you, WE SHOULD TALK! We realize our people are our most valuable asset, that is why we offer the following benefits:



  • Health, Dental, and Vision insurance

  • 401(k) retirement plan

  • Long and Short-Term disability

  • Life insurance

  • Direct deposit

  • Referral program



Your better future is ready, and we want to put the right tools in your hands to get you there. Let's go!



Looking for more opportunities with Technology Partners?


Check out jobs.technologypartners.net.



Technology Partners is an Equal Opportunity Employer. Technology Partners does not discriminate on the basis of race, color, religion, sex, national origin, age, disability or any other characteristic protected by applicable state or federal civil rights laws.

Michelle Taylor

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

If I had to sum up our relationship in one word it would be quality. Quality organization, quality employees, and they help us provide a quality product.

Mary Heger, CIO & Vice President of Ameren

Find out how our outsourced helpdesk solutions can make a difference for you today.

Learn More