View Our Website View All Jobs

Senior Database Administrator

Lucid is the world’s largest audience platform for sourcing and understanding real, deterministic data about human behavior at scale. The company has built the largest and most powerful programmatic survey exchange, and has enabled brands, agencies and partners to ask and answer more than 8 billion questions worldwide. With a pool of over 70 million respondents, Lucid delivers unprecedented access to consumers for data-driven decision making – about everything from marketing to product development in real-time. Lucid is headquartered in New Orleans with offices in London and Gurgaon.

The Database Administrator will join our global technology team. Our clients use our flagship products, Fulcrum and Samplicio.us, to manage and execute complex, large-scale online sampling projects (surveys). Our development centers are located in New Orleans, Singapore, and Manila. The Database Administrator will be part of our development team in New Orleans and work closely with development team peers, Product Management team, business and other support teams. Know SQL Server? Want the opportunity to play with SQL 2016 after the RTM? Want to get more experience in the cloud with AWS, Redshift, Dynamo or other services offered by AWS? This is the droid you have been looking for.

Essential Job Functions

  • Monitor and troubleshoot Microsoft SQL Server 2014, associated jobs and processes.
  • Monitor performance of SQL Server and database infrastructure using various performance tools.
  • Ensure problems and error conditions are promptly and appropriately addressed.
  • Establish and maintain configuration and recovery documentation for SQL Server systems.
  • Assist with SQL Server installations, database migrations, upgrades and updates, and hardware implementations.
  • Perform TSQL code review and mentoring for development staff
  • Deploy SQL Server change scripts (stored procedures, functions etc.) as needed to various environments.
  • Manage SQL Server permissions for various environments.
  • Assist development and application teams with SQL Server problem resolution.
  • Perform other related duties as required. 
  • Provides on-call support for production environments on a shared DBA rotation

Qualifications

  • 5+ years of experience in database development and production support of medium- to large-scale mission-critical MS SQL Server environments (multi- terabyte)
  • Experience with Always On or Mirroring in a production environment
  • Strong hands-on experience in Database Administration in SQL Server 2012 or 2014
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, always on or mirroring issues, connectivity issues, security issues etc.
  • Strong knowledge and experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • Knowledge and experience of SQL Server tools ( Profiler, Redgate, SSMS, PerfMon, DMVs, system SPROCs)
  • Solid knowledge and experience with Windows Server, security delegation, SPNs, firewalls etc.
  • Excellent verbal and written communication skills
  • Experience providing SQL Database Operational support to technical and development users
  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

Preferred Qualifications

  • An understanding of SSIS, SSRS, SSAS and source control (Redgate to GIT) in a database environment
  • Experience with AWS, Redshift and NoSQL
  • Experience with SQL Server 2014, In-Memory tables, DAX, MDX and Power BI
  • Someone who understands the binary language of moisture vaporators

 

At Lucid we foster a collaborative and inspiring workplace.  We pride ourselves in doing this by recruiting, hiring and retaining diverse, passionate, and forward-thinking talent. Lucid is committed to and encourages an inclusive environment and we are dedicated to providing equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. If you have a disability or special need that requires accommodation, please let us know.

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150
To comply with government Equal Employment Opportunity / Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race

Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status
I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE
I AM NOT A PROTECTED VETERAN
I DON’T WISH TO ANSWER

Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 1/31/2020
Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities.i To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • HIV/AIDS
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Please check one of the boxes below:

You must enter your name and date
Your Name Today's Date
Reasonable Accomodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.


iSection 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.


PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.