10/06/2017 updated


100 % available
SYBASE IQ DBA
India
India
Microsoft WindowsIBM AIXAuditingISO 9000UnixCapacity PlanningCommunicationDatabasesData SecurityDatabase Storage StructuresLinuxFailoverISO/IEC 27001Microsoft SQL ServersNode.js
Professional Summary :-
Technical Area :-
- 6+ years of experience in IT industry
- 6+ years of experience as Sybase IQ and ASE DBA. And 1 year experience in MS SQL DBA.
- Installation and DBA part of Sybase server and SQL server 2008.
- Maintaining data Security in Sybase, SQL, T-SQL.
- Monitor servers to optimize database performance, resource usage and physical implementations of databases
- Good methodology and solution finding skills, excellent verbal and non verbal communication, proactive approach, team building, dedication to work, eye for details and positive attitude are my forte
- Participated QMS / ISO 9001:2000, ISO 27001:2005 audits
Technical Area :-
- Databases :- Sybase IQ 12.X, 15.X, 16.X
- Operating Systems :-Unix, Linux, Windows NT, XP, Sun Solaris,AIX
- Programming Languages : -SQL, T-SQL
- Maintain database storage, perform capacity planning required create and maintain the database environments.
- Migrations of SYBASE IQ 12.7 multiplex to SYBASE IQ 16 multiplex.
- Migrations of SYBASE IQ 15.4 Simplex to SYBASE IQ 16 Simplex .
- Complete installation of SYBASE IQ12.7 and SYBASE IQ 16 multiplex.
- Upgrade IQ 16 patches and service pack.
- Developed monitoring queries in SYBASE IQ.
- Backup and Restore simplex and multiplex.
- Monitoring the IQMSG and server log, error log files.
- Change the database option for any specific requirement.
- Rebuild NON FB index in case of corruption.
- Force drops the table if entire table is corrupted.
- Creating user policy and assign policy to user.
- Adding temp file and Main file to dbspace.
- Monitoring temp and main IQ block usage.
- Synchronize secondary node with coordinator node.
- Creating new dbspace . And adding files.
- Crating Automatic fail over of coordinator node.
- Complete installation of Sybase IQ agent and SCC.
Languages
EnglishGoodHindiNative speaker