Job #1
От | cbowden@swjobs.com |
---|---|
Тема | Job #1 |
Дата | |
Msg-id | OF5F3D0AFF.D08982E2-ON0825742B.00603166-8825742B.005FF13A@swjobs.com обсуждение исходный текст |
Список | pgsql-jobs |
Hi there Here is the job I would like to place.....Is this ok? Its for an Entertainment company in Santa Monica Postgres Database Administrator This is a dynamic role where DBA will be responsible for Database Architecture, Database Design, Database Administration / Maintenance, and Database Development of a large-scale Postgres 8.x database environment. Design and Analysis Conduct fact gathering sessions with customers. Develop project estimates for database tasks. Participate in group application design & architecture activities. Provide technical assistance and guidance to engineering staff. Develop database design documentation Development and Testing Develops new complex database solutions according to defined application requirements. Performs Unit Testing and debugging of applications. Provides database support through all testing phases and general releases of software. Adheres to department programming standards and methodology. Production Support Manage database capacity planning Create and execute scripts for various database maintenance activities. Perform database tuning including monitoring, troubleshooting and optimizing performance. Plan and perform database software installations, upgrades, and patches Implement database backup and recovery strategies including high availability Troubleshoot and tune Postgres database for optimal performance Serve as escalation point for database issues Administrative Work as a member of a cross-functional, integrated development team. Work with the other Engineers to continually improve development standards and other departmental processes and documentation. Communicates plans, status and issues to management on a regular basis. Adheres to department standards, policies, procedures and industry best practices. Technical Skills and Experience Recent experience with Postgres 8.x and the development of views, functions, triggers. Design, implement, and operate 24x/7 high availability Postgres production and development databases. Define and implement maintenance procedures including Disaster Recovery, HA, DB maintenance, Backup solution, etc. Plan and support the implementation of major architectural changes. Provide direction in capacity planning, performance improvements, and storage management in partnership with System Operations and Development teams. Ongoing performance analysis, monitoring, troubleshooting, and resolution of issues. Interface with System operations and vendors to resolve problems with application/database systems. Knowledge of Linux & Unix operating system and scripting language. On-call support for production systems. Good understanding of relational database design concepts. Knowledge and experience in Logical and Physical Data Modeling. Strong Database Troubleshooting and Problem Resolution skills. Contribute to and update systems documentation as required. Capable of translating complex business needs into technical solutions. Nice to have MySQL experience. Qualification 8+ years software industry experience. 5+ years Database Administration experience. 3+ years SQL development experience. Bachelor's degree required, preferably in Computer Science. Postgres configuration and performance tuning experience. Experience in high transaction rate OLTP environment and supporting VLDBs (Terabyte +). Strong interpersonal and relationship building skills conducive to team development. Excellent communication skills, both written and verbal. Candace Bowden Account Manager/Recruiter Sharf, Woodward & Associates 5900 Sepulveda Blvd Suite 104 Sherman Oaks CA 91411 Ph: 818/989-2200 ext 241 Toll Free: 877-482-6687 ext 241 Fax: 818-756-6726 email: cbowden@swjobs.com website: www.swjobs.com http://www.linkedin.com/pub/3/a53/a02
В списке pgsql-jobs по дате отправления: