SQL Server Performance

SQL Server DBA - Production OLTP job in SF

Discussion in 'SQL Server-Related Job Postings' started by Ingenio - John, Jun 5, 2007.

  1. Ingenio - John New Member

    SQL Server Production DBA position at Ingenio in SF.

    I have the following critical position open in my company. If it looks interesting, we are interviewing right away to get this spot filled.

    You must come from an OLTP environment where you are running 100% live 24x7. Batch environment experience is not applicable.
    No maintenance windows ** you have to do everything while the DB's are up. Prefer people also coming from larger enterprise environments dealing with large DB's, Clustered environments. etc..


    Let me know ASAP and I will contact you with the details.

    John
    Ingenio, Inc.


    Job description:

    In this position, you will be:
    * Responsible for database monitoring, troubleshooting, performance tuning, high-availability strategies with SQL Server 2005 in a 24x7 production environment
    * Perform daily and monthly deployments.
    * Help Engineers and QE to debug database related issues.
    * Develop and implement replication, archiving and backup and recovery strategies
    * Anticipate hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance
    * Proactively monitor production databases and optimize stored procedures for better performance. Resolve locking conflicts/blocking and resource utilization
    * Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases and systems
    * Ensure all database environments development; Testing, QA, Staging, and Production.
    * Identify and resolve database performance issues, database capacity issues and other distributed data issues

    Requirements
    * 3 to 5 Years SQL Server production DBA experience
    * Experience with large databases with high transaction volume in a fast-paced production environment
    * Maintaining high-availability systems in a 24x7x365 E-commerce environment
    * Experience with backup & recovery, performance monitoring and tuning
    * Experience with SQL Server log shipping, replication and clustering
    * Excellent problem-solving skills, a self-starting attitude and good communication and documentation skills
    * Must be able to work in a team-oriented environment and as a member of the production support team
    * Bachelors degree in technology field or equivalent experience

    About Ingenio

    Founded in 1999, Ingenio is privately-held, extremely profitable, and growing rapidly. You'll enjoy the best of both worlds with the entrepreneurial vigor of a startup that has a compelling product offering, proven business model and an established customer base. Ingenio's suite of solutions, including the industry-leading Pay Per Call* Advertising Network, Ingenio Live!Advice, Keen and Ether seamlessly integrate the Web and the phone to help businesses large and small acquire new customers and grow revenue. With strategic partnerships including Microsoft, AOL, InfoSpace and MapQuest, Ingenio is positioned for significant growth.

    We are located in downtown San Francisco with easy access to BART, MUNI and Caltrain. Learn more about us at:

    Ingenio Corporate:http://www.ingenio.com/documents/corp/home.asp
    Ingenio PayPerCall: paypercall.ingenio.com - the industry-leading Pay Per Call Advertising Network
    Ingenio Professional Advice: www.ingenio.com/default.asp
    Ether - Earn Money Selling What You Say: www.ether.com
    Keen - Your Personal Advisor: www.keen.com

    John Hennessy
    Recuiter
    Ingenio

    201 Mission Street, Suite 200
    San Francisco, CA 94105

    415.248.4071 o
    925.890.6347 c

    johnh@ingenio.com
    www.ingenio.com


  2. ndinakar Member

    Just out of curiosity, if there is no maintenance window how do you do your deployments? and your reindeing of OLTP db?

    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************
    http://weblogs.sqlteam.com/dinakar/
  3. MohammedU New Member

    That is WHY they need DBA [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
  4. joechang New Member

    i think they will find out it is easy to talk,
    these requirements are generally drafted without input from anyone who can actually do it.

    the pattern when this happens is someone who claims to be able to do it is hired, starts planning out hw/sw, ie, to buy the solution,
    buys lots of expensive products hw & sw only to find out later that vendors expensive claims,

    I am not aware of a true 24hr requirement
    every one I have looked at was really an international market made up of distinct regions
    ie,
    North/Central/South America, Europe/Africa, & Asia

    which meant that each region could get a separatee database,
    which meant that you really did have a maintenance window

    but this was only after much arguing with dumb nuts who liked to talk 7x24
  5. satya Moderator

    Start employment with them and post questions here asking for Performance help [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ndinakar</i><br /><br />Just out of curiosity, if there is no maintenance window how do you do your deployments? and your reindeing of OLTP db?<br /><br />***********************<br />Dinakar Nethi<br />SQL Server MVP<br />***********************<br /<a target="_blank" href=http://weblogs.sqlteam.com/dinakar/>http://weblogs.sqlteam.com/dinakar/</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">

Share This Page