Lead SQL DBA :: Columbia, SC

2013-12-11 Thread Avinash Bhushan
Hi Partners,

Please let me know your interest.

 

 

Direct Client :: Phone Hire

 

Location: Columbia, SC

Duration: 9+ months

Rate: Open

 

SCOPE OF THE PROJECT:

The position is focused on planning, developing, documenting  exchanging
knowledge with onsite team using industry best practices. Typical work...
These software solutions will primarily be centered on installing,
configuring, and customizing one to many Microsoft SQL Servers. Migrating
from SQL 2008 R2 to SQL 2012.

 

DAILY DUTIES / RESPONSIBILITIES:

Database Administrator will work with network engineers and technical staff.
The position is focused on planning, developing, documenting  exchanging
knowledge with onsite team using industry best practices.

 

Duties and responsibilities of the Database Administrator include
performance of the following actions:

. establishing the needs of users and monitoring user access and
security;

. monitoring performance and managing parameters to provide fast
query responses to front-end users;

. mapping out the conceptual design for a planned database in
outline;

. considering both back-end organization of data and front-end
accessibility for end-users;

. refining the logical design so that it can be translated into
a specific data model;

. further refining the physical design to meet system storage
requirements;

. installing and testing new versions of the DBMS;

. maintaining data standards, experience with database hardening
and administration in accordance with CIS, SCAP, NIST or SANS guidelines;

. writing database documentation, including data standards,
procedures and definitions for the data dictionary (metadata);

. controlling access permissions and privileges;

. developing, managing and testing back-up and recovery plans;

. ensuring that storage, archiving, back-up and recovery
procedures are functioning correctly;

. capacity planning;

. working closely with IT project managers, database programmers
and Sharepoint developers;

. communicating regularly with technical, applications and
operational staff to ensure database integrity and security;

. commissioning and installing new applications and customizing
existing applications in order to make them fit for purpose.

 

Skills Needed:

. 10+ years of experience in database development and support in
MS SQL Server environments.

. Expert experience in implementing operational automation.

. Strong knowledge of how indexes, index management, integrity
checks, configuration, patching. How statistics work, how indexes are
stored, how they can be created and managed effectively.

. Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC,
SSCM, PerfMon, DMVs, system sprocs)

. SQL Development - ability to write and troubleshoot SQL Code
and design ( stored procs, functions, tables, views, triggers, indexes,
constraints )

. Solid acquaintance with windows server, security delegation,
SPNs, storage components.

. Documentation skills for processes and procedures ( creating
KBs, runbooks, topology etc )

. SQL Database Operational support to tech users

 

 

REQUIRED EDUCATION:

Bachelor's degree in Computer Science, Engineering, or equivalent experience
required. Years of experience can substitute for formal education.

 

Thanks

Avinash

 

Avinash Bhushan

Software People Inc.

www.softwarepeople.us

avinash.bhus...@softwarepeople.us

Ph: 631-739-8996

Fax: 631-574-3122

Certification: SBA 8a/SDB, NJ MWBE, NY MWBE, VA SWaM, DE OMWBE, MA MWBE.

 

-- 
You received this message because you are subscribed to the Google Groups
SPINC_Partners group.
To unsubscribe from this group and stop receiving emails from it, send an
email to spinc_partners+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
You received this message because you are subscribed to the Google Groups 
REQSRESUMES group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reqsresumes+unsubscr...@googlegroups.com.
To post to this group, send email to reqsresumes@googlegroups.com.
Visit this group at http://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/groups/opt_out.


Lead SQL DBA :: Columbia, SC

2013-12-10 Thread Avinash Bhushan
Hi Partners,

Please let me know your interest.

 

Please only share the candidate having 10+ years of experience.

 

Direct Client :: Phone Hire

 

Location: Columbia, SC

Duration: 9+ months

Rate: Open

 

SCOPE OF THE PROJECT:

The position is focused on planning, developing, documenting  exchanging
knowledge with onsite team using industry best practices. Typical work...
These software solutions will primarily be centered on installing,
configuring, and customizing one to many Microsoft SQL Servers. Migrating
from SQL 2008 R2 to SQL 2012.

 

DAILY DUTIES / RESPONSIBILITIES:

Database Administrator will work with network engineers and technical staff.
The position is focused on planning, developing, documenting  exchanging
knowledge with onsite team using industry best practices.

 

Duties and responsibilities of the Database Administrator include
performance of the following actions:

. establishing the needs of users and monitoring user access and
security;

. monitoring performance and managing parameters to provide fast
query responses to front-end users;

. mapping out the conceptual design for a planned database in
outline;

. considering both back-end organization of data and front-end
accessibility for end-users;

. refining the logical design so that it can be translated into
a specific data model;

. further refining the physical design to meet system storage
requirements;

. installing and testing new versions of the DBMS;

. maintaining data standards, experience with database hardening
and administration in accordance with CIS, SCAP, NIST or SANS guidelines;

. writing database documentation, including data standards,
procedures and definitions for the data dictionary (metadata);

. controlling access permissions and privileges;

. developing, managing and testing back-up and recovery plans;

. ensuring that storage, archiving, back-up and recovery
procedures are functioning correctly;

. capacity planning;

. working closely with IT project managers, database programmers
and Sharepoint developers;

. communicating regularly with technical, applications and
operational staff to ensure database integrity and security;

. commissioning and installing new applications and customizing
existing applications in order to make them fit for purpose.

 

Skills Needed:

. 10+ years of experience in database development and support in
MS SQL Server environments.

. Expert experience in implementing operational automation.

. Strong knowledge of how indexes, index management, integrity
checks, configuration, patching. How statistics work, how indexes are
stored, how they can be created and managed effectively.

. Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC,
SSCM, PerfMon, DMVs, system sprocs)

. SQL Development - ability to write and troubleshoot SQL Code
and design ( stored procs, functions, tables, views, triggers, indexes,
constraints )

. Solid acquaintance with windows server, security delegation,
SPNs, storage components.

. Documentation skills for processes and procedures ( creating
KBs, runbooks, topology etc )

. SQL Database Operational support to tech users

 

 

REQUIRED EDUCATION:

Bachelor's degree in Computer Science, Engineering, or equivalent experience
required. Years of experience can substitute for formal education.

 

Thanks

Avinash

 

Avinash Bhushan

Software People Inc.

www.softwarepeople.us

avinash.bhus...@softwarepeople.us

Ph: 631-739-8996

Fax: 631-574-3122

Certification: SBA 8a/SDB, NJ MWBE, NY MWBE, VA SWaM, DE OMWBE, MA MWBE.

 

-- 
You received this message because you are subscribed to the Google Groups 
REQSRESUMES group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reqsresumes+unsubscr...@googlegroups.com.
To post to this group, send email to reqsresumes@googlegroups.com.
Visit this group at http://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/groups/opt_out.