Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+


Job ID : 15466

Job Title : Sr. SQL DBA

Location : Exton, PA

Company Name : Genzeon Corporation

Industry : Information Technology

Salary : $76,000 - $129,000  per year

Job Type : Fulltime

Posted on: 2020-09-09


Required Skills : SQL, SQL Queries, Stored Procedures, Database Administration, Data Warehousing

Benefits : No benefits are available


Responsibilities:The nature of the position involves being responsible for operations support for a large scale SQL Server environment supporting platform in a Data Warehouse environment. The machines consist of 64 CPUs and 1 Terabyte of Ram and the main responsibilities of this individual will be to keep this environment running at an optimal level with a strong performance in mind. When issues arise it will be this individual's responsibility to either personally rectify the issue or delegate it to the appropriate development team and instruct them on how to fix the problem. The entire Data Warehouse is built on Column Store Indexes, so we are looking for someone with deep expertise in this area.

Required Skillsets:

  • SQL Queries and Transact Stored procedures to be used for performance tuning purposes.
  • Database Administration and Data Warehousing including:
  • Database Architecture & Design.
  • Data Warehousing including being capable of designing and maintaining schemas.
  • Performance optimization and tuning including detect performance bottlenecks using scripts.
  • High Availability and Disaster Recovery.
  • Restore databases.
  • Configure database backups
  • Configure 3rd party and in-house analytics tools.
  • A “nice to have” would be any experience with Service Broker Cues for parallel execution. (If you do not have this experience, our Sr. Architect will provide training on this.)

Latest Jobs For You

  • Software Developer Engineer in Test SDET

    Louisiana Economic Development Bossier City, La.

    Responsibilities: Design, develop and implement test plans, manual test scripts, and automated...

    View Job
  • Senior SDET Engineer

    Cynet Systems Hartford, CT

    Job Description: Middle and Large Commercial IT is looking for an experienced, energetic, and ...

    View Job
  • Sr Software Test Engineer

    COX Enterprises Irvine, CA

    Job Description: A highly qualified Senior Quality Assurance Test Automation Engineer will ...

    View Job
  • Network Engineer

    Tech USA Downingtown, PA

    Responsibilities: Review and provide input to new technical requirements Ability to ...

    View Job
  • Sr. Big Data Developer

    Synechron Weehawken, NJ

    Skill Requirements: Hands-on expertise with Big data Technologies (Apache Spark, Hadoop, HDFS,...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First