****NY,NY (212) Immediate Opening Sr. MS SQL DBA***
Manish Vipani
Job Title: SQL DBA
Job Location: NY: New York
Area Code: 212
Pay Rate: DOE
Job Length: Contract
Start Date: 2003-05-01
Job Title
_________
Sr. SQL Server Database Administrator (DBA)
Job Identification
__________________
The Job is within technology department, and directly reports to Technology
Manager
Job Mission
___________
The SQL DBA must work with software developers to identify table locks
scenarios. He/she must also ensure the safety and integrity of the data
servers.They must optimize the servers so that they can be exploited to
their fullest potential. this includes making sure all code, tables, and
indexes are properly built, as well as uphold the standards set for
development and administration.
Job Duties:
___________
The position is for a DBA who would concentrate on the Administration and
Maintenance of the machines. However, the DBA must be knowledgeable enough
in TSQL to assist with Data development
Administration/Maintenance focus:
1. Ensure the safety of the data through backup and recovery plans
2. Maintain the space and memory issues of the Servers hosting the data
3. Continually tune the software and hardware for optimal performance
4. Document all changes to Databases
5. Manage security on Databases
6. Track performance of machines to help identify bottlenecks and to plan
for future database sizing
7. Investigate new technologies and methods for database growth and
expansion
Development
1. Create scripts stored procedures for recurring tasks
2. Assist application developers in their database development
3. Review ALL stored procedure and tables to ensure they meet the companies
database standards
4. Recommend, build, and analyze all indexes.
5. Create Jobs for regular maintenance tasks (index rebuilds, auto-emailing
etc)
6. Help stress and analyze new applications before they reach servers
Job Specifications:
___________________
· DBAs must be self-starters. Their responsibilities are huge, and must
see them that way. If something needs to be done, they must take ownership
· They should also be able to communicate well with other technical persons.
A DBA will need to communicate with system operations, developers, business
owners and each other. Open opinions and discussions are essential for the
Data team to be successful
· Obviously SQL knowledge is essential, but also is the ability to recognize
when they do not know something, and then to go out and find the right
answer through research or discussion with others who are experienced. I
don't expect the DBA to know every single thing about databases, but I do
expect them to be willing to go out and find out what they need to know.
· Organization is necessary especially for the admin side as there are many
things going on within a database. everything must be in order and easily
referenced.