Sr sql dba
Company Name:
Aurionpro Solutions
o 5 year DBA from very large environment. 1000+Databases, 85 Servers, 4 different versions of SQL
o Someone who can write a roadmap for SQL migration/upgrade.
o Knows monitoring tools, performance tuning
o Strong project planning, scripting
o Person will need to provide technical samples (scripts, proj plans, wire diagrams, migration roadmaps)
o Data Warehouse experience not needed
Essential
job
Functions
1. Develops database standards and specifications for data manipulation with Senior Applications Development
manager
. Applies database systems analysis techniques and procedures to design, develop, implement, maintain and support databases.
2. Works closely with IT project managers and Applications Developers to evaluate and install new applications and integrate them into the SQL server. Reviews and edits SQL code developed by Applications Developers and department system administrators and provides timely feedback. Coordinates team members to ensure collaborative efforts result in maximum efficiency. May be required to develop, design, maintain and support software applications.
3. Maintains SQL Server client and server software to current stable service pack levels. Creates test environment and tests service packs prior to their installation in the production environment.
4. Tests, corrects errors, and modifies changes to programs or to databases. Reviews project requests describing database user needs, estimating time and cost required to complete project. Selects and enters codes to monitor database performance and to create production database. Coordinates with programmers and analysts to make changes to database management system. Reviews workflow charts developed by programmer analyst to understand tasks
computer
will perform.
5. Documents operating procedures and database design specifications for applications to be developed.
6. Serves as a liaison with vendors on the implementation of new packaged systems or upgrades to existing systems.
7. Creates data warehouses and designs data integration processes. Writes logical and physical database descriptions, including location, space, access method, and security. Establishes and calculates optimum values for database parameters. Develops data model describing data elements and how they are used. Codes database descriptions and specific identifiers of database to management system, or directs others in coding descriptions.
8. Oversees server roles and database security procedures to control data access and server privileges.
9. Sets up and manages backups, log shipping and recovery.
10. Programs scripts for database monitoring and automating routine tasks.
11. Troubleshoots database-related problems and backs up User Support to resolve problems they cannot resolve, including specialized and/or high impact messaging issues. Troubleshoots user problems that may require visiting the user directly. Contributes to and updates the solutions database and the projects management database.
12. Periodically reviews server disk capacity and usage to ensure proper database growth and determine the necessity for server expansion to ensure adequate database capacity.
13. Proactively maintains and expands knowledge of trends, developments and new technologies that impact database design and operations. Researches, evaluates and provides input on database products and researches, evaluates and recommends enhancements to current systems and methods of operating.
14. Responsible for designing, implementing and maintaining the highest level of security.
15. Supports off hours (evening, weekends and holiday) installations and upgrades as needed.
16. Participates in departmental project teams and task forces designed to streamline workflow and/or resolve issues; assists with various projects and initiatives as assigned.
17. Assumes additional responsibilities as requested.
Qualifications
1. Bachelor's Degree in computer science or equivalent technical knowledge. Microsoft Certified Database Administrator Certification preferred.
2. 5-7 years of database experience.
3. Comprehensive knowledge of database administration and system analysis including design, installation and troubleshooting of MS SQL server on Windows server platforms. Experience using SQL server monitoring tools.
4. Thorough command of the industry language and the ability to effectively communicate technical information to a variety of technical and non-technical users.
5. Strong analytical and problem solving skills, ability to organize and prioritize multiple assignments, use initiative and judgment to accomplish results, participate as a team leader or member of a team, work under pressure and complete job assignments in an accurate, timely and professional manner.Estimated Salary: $20 to $28 per hour based on qualifications.
Aurionpro Solutions
o 5 year DBA from very large environment. 1000+Databases, 85 Servers, 4 different versions of SQL
o Someone who can write a roadmap for SQL migration/upgrade.
o Knows monitoring tools, performance tuning
o Strong project planning, scripting
o Person will need to provide technical samples (scripts, proj plans, wire diagrams, migration roadmaps)
o Data Warehouse experience not needed
Essential
job
Functions
1. Develops database standards and specifications for data manipulation with Senior Applications Development
manager
. Applies database systems analysis techniques and procedures to design, develop, implement, maintain and support databases.
2. Works closely with IT project managers and Applications Developers to evaluate and install new applications and integrate them into the SQL server. Reviews and edits SQL code developed by Applications Developers and department system administrators and provides timely feedback. Coordinates team members to ensure collaborative efforts result in maximum efficiency. May be required to develop, design, maintain and support software applications.
3. Maintains SQL Server client and server software to current stable service pack levels. Creates test environment and tests service packs prior to their installation in the production environment.
4. Tests, corrects errors, and modifies changes to programs or to databases. Reviews project requests describing database user needs, estimating time and cost required to complete project. Selects and enters codes to monitor database performance and to create production database. Coordinates with programmers and analysts to make changes to database management system. Reviews workflow charts developed by programmer analyst to understand tasks
computer
will perform.
5. Documents operating procedures and database design specifications for applications to be developed.
6. Serves as a liaison with vendors on the implementation of new packaged systems or upgrades to existing systems.
7. Creates data warehouses and designs data integration processes. Writes logical and physical database descriptions, including location, space, access method, and security. Establishes and calculates optimum values for database parameters. Develops data model describing data elements and how they are used. Codes database descriptions and specific identifiers of database to management system, or directs others in coding descriptions.
8. Oversees server roles and database security procedures to control data access and server privileges.
9. Sets up and manages backups, log shipping and recovery.
10. Programs scripts for database monitoring and automating routine tasks.
11. Troubleshoots database-related problems and backs up User Support to resolve problems they cannot resolve, including specialized and/or high impact messaging issues. Troubleshoots user problems that may require visiting the user directly. Contributes to and updates the solutions database and the projects management database.
12. Periodically reviews server disk capacity and usage to ensure proper database growth and determine the necessity for server expansion to ensure adequate database capacity.
13. Proactively maintains and expands knowledge of trends, developments and new technologies that impact database design and operations. Researches, evaluates and provides input on database products and researches, evaluates and recommends enhancements to current systems and methods of operating.
14. Responsible for designing, implementing and maintaining the highest level of security.
15. Supports off hours (evening, weekends and holiday) installations and upgrades as needed.
16. Participates in departmental project teams and task forces designed to streamline workflow and/or resolve issues; assists with various projects and initiatives as assigned.
17. Assumes additional responsibilities as requested.
Qualifications
1. Bachelor's Degree in computer science or equivalent technical knowledge. Microsoft Certified Database Administrator Certification preferred.
2. 5-7 years of database experience.
3. Comprehensive knowledge of database administration and system analysis including design, installation and troubleshooting of MS SQL server on Windows server platforms. Experience using SQL server monitoring tools.
4. Thorough command of the industry language and the ability to effectively communicate technical information to a variety of technical and non-technical users.
5. Strong analytical and problem solving skills, ability to organize and prioritize multiple assignments, use initiative and judgment to accomplish results, participate as a team leader or member of a team, work under pressure and complete job assignments in an accurate, timely and professional manner.Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
