*Job Title: SQL DBA*

*Location: San Diego, CA*

*Duration: 6+ months Contract*



·        Good understanding of MS SQL

·        Architecture,Filegroups,Partitioning,Schemas,Snapshots,C38Memory
etc.

·        Installation and Configuration of SQL Server Pre-requisites.

·        SQL Server Datbase Basic Administration and Latest Features.

·        SQL Server user account management

·        Test and Apply Patches and Service Packs

·        Migrate Databases.

·        Database Resource Management and Task Scheduling.

·        Capacity Planing in terms of Growth of Database.

·        Experience in basic Performance Tuning and Monitoring.

·        Availibility Management for Databases.

·        Handling of daily issues (Blockings, Long running transaction,
Deadlocks etc)

·        Good understanding of Transact SQL.

·        Automating SQL Server tasks (SQL Jobs, Windows scripts, etc.)

·        Troubleshoot issues related to TempDb ,Transaction Log and System
Databases

·        Instance/Database monitoring/C39configuring DB Mail/SQL Mail and
Alerts & Operators

·        Good knowledge of Index Management & Statistics

·        Basic Knowledge of SSIS, SSRS.

·        Knowledge and troubleshooting Issues related to HA(Replication,
Logshipping, Mirroring, Clustering)

·        Scheduling Database Backups, taking Full and Transaction Log
Backups.

·        Implementing SQL Server Database Security Policy, Auditing

*Brahmdeep Singh*

*Pyramid Consulting, Inc.*

SEI-CMMI Level 3

Email: [email protected]

Linkedin: http://www.linkedin.com/in/brahmdeep

Office: (770) 255-7589 /Cell: (404)891-0476

Fax: 678.840.2109

USA | UK | India



*2011 GMSDC Supplier of the Year (Class IV)*


 ------------------------------

http://www.pyramidci.com
<https://mail.pyramidci.com/owa/redir.aspx?C=37994e95989a4704840589005555dcac&URL=http%3a%2f%2fwww.pyramidci.com%2f>

DISCLAIMER

PYRAMID cannot guarantee that e-mail communications are secure or
error-free, as information could be intercepted, corrupted, amended, lost,
destroyed, arrive late or incomplete, or contain viruses.

-- 
You received this message because you are subscribed to the Google Groups 
"US_IT.Groups" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/us_itgroups.
For more options, visit https://groups.google.com/d/optout.

Reply via email to