|
Sr. Postgre SQL Database Administrator Location: Princeton, NJ Duration: 6+ months Start date: Immediate Special Skills and/or Requirements
·
Performs all Postgre Database Administration related activities for major CLIENT projects independently with minimal supervision. ·
Willing to participate and provide 24x7 On-Call Rotation support. ·
Strong capability and ability to resolve highly technical and complex database and infrastructure related issues on their own before they impact production and CLIENT business. ·
Provides technical expertise to the development of solutions for such items as DBMS tools and utilities usage, database administration, backup and recovery, database performance tuning
and monitoring. ·
Performs database migrations, upgrades and structure migrations. ·
Ability to influence development organizations to comply with database best practices and CLIENT database standards and practices. ·
Runs transaction access path analysis sessions with application developers, analyzing specifications and code to ensure that data access and database designs are as efficient as possible.
Make recommendations for improvements in these areas, if necessary. ·
Fully utilizes CASE tools to develop, or modify, physical database designs from logical designs, using the logical design, discussion with the Data Analyst, application development reviews,
and documented results from transaction access path analysis sessions as input. ·
Assures quality of database analysis and design across projects, thus enabling company-wide data reusability. ·
Trouble-shoots database and/or software problems as they apply to design, implementation, or installation activities. ·
Schedules and coordinates database maintenance activities including such items as database reorganizations and restructures. ·
Coordinates and/or participates in database stress tests, analyzes results, and makes recommendations for design or coding changes based upon those results. ·
Participates in on-call, overnight off-hour production problem resolution activities. ·
Develops and maintains DBMS related standards and procedures, knows where they are located, and makes full use of them. Follows CLIENT software development processes. ·
Researches, evaluates, and tests new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications. ·
Monitors current DBMS performance and develops procedures, where necessary, to improve the DBMS environment as required. ·
Identifies and supports quality improvement initiatives. ·
Performs other assignments to comply with the SR&T corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic
initiative/directive. ·
Complies with all CLIENT security and audit standards. Ensures security of company information by ensuring database is secure and monitors environment to identify improper access.
·
5+ Years as a PostgreSQL Database Administrator in ver 8.x and 9.x with Postgres Advanced Server using Enterprise Manager and SQL analyzer. ·
Experienced with Linux internals. ·
PostgreSQL administration, including: installation, initialization, authentication, catalog navigation, query/database tuning, resource contention analysis, backup and recovery, standby,
replication, data export/import, and monitoring etc. ·
Postgres Replication and data encryption. ·
Proficiency for psql. ·
Database operation, to support developers in making scalable decisions in schema design and data processing models. ·
Setting up database/ user and service accounts security and audit procedures.
·
Strong capability and ability to resolve highly technical and complex database and infrastructure related issues on their own before they impact production and CLIENT business. ·
Provides technical expertise to the development of solutions for such items as DBMS tools and utilities usage, database administration, backup and recovery, database performance tuning
and monitoring. ·
Assures quality of database analysis and design across projects, thus enabling company-wide data reusability. ·
Trouble-shoots database and/or software problems as they apply to design, implementation, or installation activities. ·
Schedules and coordinates database maintenance activities. ·
Coordinates and/or participates in database stress tests, analyzes results, and makes recommendations for design or coding changes based upon those results. ·
Develops and maintains DBMS related standards and procedures, knows where they are located, and makes full use of them. Follows CLIENT software development processes. ·
Researches, evaluates, and tests new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications. ·
Monitors current DBMS performance and develops procedures, where necessary, to improve the DBMS environment as required. ·
Identifies and supports quality improvement initiatives. ·
Performs other assignments to comply with the SR&T corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic
initiative/directive. ·
Complies with all CLIENT security and audit standards. Ensures security of company information by ensuring database is secure and monitors environment to identify improper access.
·
Experience in alternative technology (SQL Server, Oracle) is a big Plus. Regards, Steven Smith
295 Durham Avenue, Suite A, South Plainfield NJ - 07080 Direct: 908-360-8035 Ph : 908 325 3555 X 122 Fax: 732-230-6969 Email: steven@xxxxxxxxxxxxxxx |
