Browse
Employers / Recruiters
Negotiable
Full-time
Continue
By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.
Location: Calabasas,CA
Duration: 12 months to hire

Interview Mode: Phone or Skype

Hands-on experience with planning, development, implementation, utilization, monitoring, and administration of databases, primarily MS SQL Server They are also responsible for the security, integrity,
efficiency, scheduling and documentation of the databases. They will establish and enforce written guidelines, rules and standards. Must be goal oriented and should be flexible to work with matrix teams including off-shore development resources.   
 
Responsibilities:
  • Manage production database
  • Performance tuning
  • Archival scripts and Schedule
  • Manage size
  • Setup Backups
  • Monitor for Performance
  • Review and optimize queries
  • Day to day management of databases.
  • Setting up new Dev/QA environment from production data
  • Manage and troubleshoot ETL jobs
  • Manage and troubleshoot data loads
Requirements:
Critical hands-on experience in:
  • Performance tuning
  • Review and optimize queries
  • Setting up new Dev/QA environment from production data
Other requirements:
  • 7-10 years of relevant work experience
  • Expert knowledge of SQL Server, its parts and dependencies including hardware and software requirements (SSRS)
  • In depth knowledge of SQL Server Management Studio (SSMS), T-SQL, and SQL troubleshooting
  • SQL Server via Excel and Access
  • 5+ years in Database Design, Development, Administration of MS SQL Server in Production, Development and QA environments.
  • Knowledge on SQL DTS packages
  • Knowledge on additional ETL tools
  • Experience with SQL Server Data Warehouse concepts and implementation to provide reporting solutions for the organization.
  • Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.
  • Expert in database Performance Tuning, using tuning methodology, including enterprise manager, query plans, performance views, trace files and other SQL Server tools.
  • Expert in writing T-SQL, including complex stored procedures, functions, views and triggers.
  • Bachelor's degree in a related area
  • Good knowledge of configuration management concepts, release management, change management concepts, industry standards and best practices
  • Experience in fine tuning indexes for performance improvement.
  • Experience implementing data partitioning to improve performance.
  • Experience in security concepts as they relate to SQL Server.
  • Experience in day to day monitoring of system performance using tools such as SQL Sentry, New Relic, and CloudWatch.
  • Able to create effective Backup and Recovery plans by Transactional Log and Full Database Backups.
  • Experienced and knowledgeable of high availability and disaster recovery solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping and Database Mirroring.
Should Have:
  • Excellent personal presence with proven ability to work with all levels of management internally and externally
  • Experience in using Excel to create Pivot tables, and accessing multidimensional cubes from Excel.
  • Experience with very large databases (VLDB)
  • Experience with Data Warehouse platforms such as Redshift and reporting tools such as SSRS and Bime.

Last updated on May 31, 2017

See more

More jobs at ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo

Analyzing

Stamford, Connecticut

 · 

30+ days ago

Dallas, Texas

 · 

30+ days ago

Atlanta, Georgia

 · 

30+ days ago

Hanover, New Jersey

 · 

30+ days ago

New Hartford, New York

 · 

30+ days ago

More jobs like this

Analyzing
Data Architect
C
crjdnwsnowo2i4nz45b1teboszrxlg0351vr73gpqw7yanury9u287prckhdnkww

Irvine, California

 · 

30+ days ago

Data Integration Engineer
T
two95-international-inc-3

Remote

 · 

30+ days ago

Data Architect$75+ / hour
D
dhjdnwh4qm62pb5vm2o4tbd72ej7oa01f47beu0d9d984ckrwi58r2ocg36n82t5

Philadelphia, Pennsylvania

 · 

30+ days ago

Data Architect
3
3djdnw5yqdh8wl3frr5t6561tvvokq01affwpxt3lcutzo4f8yt1aeiy3msk02or

Austin, Texas

 · 

30+ days ago

Cloud Engineer - Azure Automation
D
d1jdnwvhbdgegwtuivnn7ap9pt7oxh03c5khec0dlwfqm0mxseydguueduceafch

Raleigh, North Carolina

 · 

30+ days ago

Database Administrator
R
rsjdnwc9jel4i3xyjsm3m8vnhrmayk037bphn44zg3i1bl3dcjtqhqlclsisinpr

Raleigh, North Carolina

 · 

30+ days ago

Enterprise Data Architect
B
b6jdnwcpcemgg8el3r9winlpunj8hc038b1vkhowrzxn9gitznreodi38t7rirkp

Denver, Colorado

 · 

30+ days ago

Data Warehouse Developer III
F
fvjdnwvwi7yecmymd9si3it1ointo80348emvd7mgqh749rpbe3n811jnfkeb228

Boston, Massachusetts

 · 

30+ days ago

Data Warehouse Architect
B
bpjdnwgu38j84sabghlw7x9mmxinki0297vano3tk7rjth7i2es8ayn8uhi63zh7

Fort Wayne, Indiana

 · 

30+ days ago

Data Architect$140-150k
4ujdnwqsdebu7m13em5f0pt5dw80o500d7dv9cbq5ebzngb7yk0n43mjtefnbx0d

Jersey City, New Jersey

 · 

30+ days ago

Developed by Blake and Linh in the US and Vietnam.
We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord
Changelog
🚀 LaunchpadNov 27
Create a site and sell services based on your resume.
🔥 Job search dashboardNov 13
Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.
🫡 Cover letter instructionsSep 27
New Studio settings give you control over AI output.
✨ Cover Letter StudioAug 9
Automatically generate cover letters for any job.
🎯 Suggested filtersAug 6
Copilot suggests additional filters above the results.
⚡️ Quick applicationsAug 2
Apply to jobs using info from your resume. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.
🧠 Job AnalysisJul 12
Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status