Job Role:
* To monitor and maintain OLTP and OLAP database systems in a PostgreSQL environment.
* Should ensure database backups and disaster-recovery plans are current.
* Should participate in capacity planning and system monitoring improvements.
* Should participate in capacity planning and system monitoring improvements.
* To develop and improve performance of SQL, functions, and procedures to ensure timely access to data.
* Responsible in developing knowledge of web analytics and click-stream data warehousing techniques.
* Should good knowledge of Search Engine Optimization (SEO) or Search Engine Marketing (SEM) principles and techniques.
Skills Required:
* 2+ years of experience database administration/development (installation, tuning, replication, backup, and monitoring of database systems), UNIX/Linux OS and concepts (processes, cron, bash, top).
* Expertise in RDBMS such as Oracle, Sybase, SQL Server, and experience in PostgreSQL would be an added advantage.
* Sound Understanding of database administration tasks and data models.
* Should be comfortable in writing and tuning SQL.
* Should be familiar with source control using CVS or Subversion.
* Should be experienced in creating and reading data models (ERDs).
* Should be familiar with indexing and other optimization techniques.
* Should have the ability to write in pl/pgsql, pl/perl or pl/sql.
* Must have thorough understanding of relational models, joins and sub-queries.
* Should have the ability to be "on-call" with the client 1 week per month.
* Must possess effective interpersonal and communication skills and ability to work successfully in a team environment.
* Good organizational and time-management, prioritization skills are a must.
* Should be adaptable to rapidly-changing environment.
Mail your CV to: speed@synechron.com with subject line as "Application for Postgre SQL DBA"
Click here to get FREE SMS updates on your mobile about Job openings.
No comments:
Post a Comment