SQL Server Performance

Senior Infrastructure Database Administrator – Ale

Discussion in 'SQL Server-Related Job Postings' started by spowell, May 11, 2005.

  1. spowell New Member

    I am a Symantec SQL Server DBA Manager I have a position for my DBA team. Here is the job description:
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sr Security Infrastructure Adm
    Alexandria, VA, USA
    Consulting

    Job Duties
    Senior Infrastructure Database Administrator will work as part of a DBA team that provides 24x7 support of all technical aspects MS SQL Server in a 100+ server enterprise environment. Primary support and duties are performed during standard business hours, however 24x7 hour on-call support during off hours and weekends is required on a rotation schedule.

    The production environment is an OLTP 1000+ distributed database system, consisting of databases ranging in size from small-medium to VLDBs (>400 gig). DBA responsibilities include:
    ·Automation of MS SQL Server maintenance and alerting.
    ·Implement and maintain database security.
    ·Monitor failed and long running MS SQL Server jobs.
    ·Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
    ·Support and maintenance of MS SQL Server Log Shipping.
    ·Support and maintenance of MS SQL Server Transactional Replication.
    ·Setup new MS SQL Server instances and databases.
    ·Documentation of MS SQL Server system environment, setup, maintenance and standards.
    ·Capacity planning of MS SQL Servers.
    ·Work closely with technically savvy users and developer to resolve database production problems.

    Requirements
    Education and training:
    Symantec's managed security service is seeking an experienced Midlevel to Senior candidate with a minimum of 1-2 years experience administering MS SQL Server. Bachelors in Computer Science or similar Engineering Degree; can substitute 3-5 years of experience in the IT field. Must have knowledge of MS SQL Sever best practices. MCSE/MCDBA is desirable.

    Required Skills:
    ·Strong understanding of major components of MS SQL Server architecture.
    ·Hands on experience with SQL Enterprise Manager, Query Analyzer, Profiler, Data Transformation Services.
    ·Strong experience in database Backup, Restore and Recovery procedures.
    ·Strong SQL programming skills including, developing & testing T-SQL stored procedures & queries.
    ·Strong understanding of relational database modeling and design.
    ·Experience in tuning and analyzing SQL Server databases for performance.
    ·Performance monitoring experience using Windows Performance Monitor and MS SQL Server Profiler.
    ·Candidates must have excellent trouble shooting skills.

    ·Other Skills:
    Ability to work both independently and as a part of a team.
    Strong desire and passion to learn new technologies.
    Fluent in English language good written and verbal skills.
    Good problem solving and documentation skills.
    Ability to perform challenging assignments under general supervision.
    Demonstrated commitment to quality.

    Desirable/bonus Skills (for additional consideration):
    ·Knowledge of Windows 2000/2003 operating systems and SQL server in a clustered environment are advantageous.
    ·Knowledge of SCSI and SAN storage practices is a plus.
    ·Knowledge of Dimensional modeling and OLAP services in a data warehousing environment is a plus.
    ·Knowledge of networking and systems security.

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    We are flexible on some of the jobs requirements (e.g. years experience). If one has solid MS SQL Server skills (depth of knowledge) and a decent command of the English language your have meet the minimal requirements.

    If you are interested send me an email at: sean.powell@monitoredsecurity.com or spowell71@hotmail.com.

    Recruiters please do not contact me.

    Thanks,
    Sean Powell

Share This Page