Sql Server Project Manager
Resume:
Subhash Khatter ORACLE
**g Certified Associate
*******.*******@*****.***
Highly motivated, energetic, dedicated and results-oriented Information
Technology professional charged with prospect for growth and desire to
learn more, seeking an opportunity to obtain a challenging position of
Junior DBA to utilizing broad-based skills in Database Administration,
Network Engineering, and Software Quality Assurance.
. Experience in Installation, configuration and maintenance of SQL and
Oracle Server.
. Backend skills in creating SQL objects like Tables, Views, Indexes,
Triggers etc.
. Experience in Database backup and disaster recovery procedures.
. Broad experience in installing and configuring routers, switches, and
hubs.
. Ability to configure networks including firewall, TCP/IP, VPN, DNS,
and desktop.
. Knowledge of importing, exporting, running queries with SQL/Oracle
Server.
. Worked in Production (24x7), QA and development databases.
. Knowledge of Analysis services, Reporting Services and SQL Server
Clustering.
. Strong background in a disciplined software development life cycle
(SDLC) process.
. Experience in Pharmaceutical, Financial and E-Commerce industries.
Technical Skills:
Operating Systems: Windows98/2000/XP/Vista, Server 2003, UNIX, Solaris
2.8
Languages: SQL, PL/SQL, HTML C, C++, Visual Basic
RDBMS: Oracle 8i, 10g, SQL Server2005 and 2008
Tools: SQL Server Management Studio, RMAN, Oracle
Enterprise Manager,
PL/SQL Developer, Toad, Test Director,
Bugzilla.Team Track
Hardware: IBM, HP, DELL
Professional Experience:
Tejes Services.
Oct, 2010-March2011
Junior DBA
Contract Job
Roles and Responsibilities:
. Installing and Maintaing SQL Server and application tools. Ensure
database systems operate efficiently and securely.
. Manage internal databases for planning and testing stages through
implementation and support. Involved in the Analysis and Design.
. Created Database and Database Objects like Tables, Stored Procedures,
Views, Triggers, jobs, user defined data types and functions.
. Configuring user creation, their roles and privileges profiles to
control access over database object and managing server permissions.
. Organization of databases on different disks to reduce disc
contention.
. Implemented database shutdown, startup scripts to synchronize with
backup and recovery utilities.
. Controlled login security, accessibility, scheduled tasks, backups and
recovery.
. Proactively monitor databases performance and checking warnings and
alerts and take appropriate actions using Sql Server Management
Studio.
. Monitor CPU usage, database performance, I/O, network status on the
OS side
. Assist in tuning of the database structures and OS environment to
maintain peak performance. Participate in Disaster Recovery exercises.
. Pro actively identifying and troubleshooting problems using SQL
Profiler.
Environment: SQLServer 2008, SSIS ETL Tool, SQL Server Management
Studio, Windows XP Professional and SQL Profiler.
Wells Fargo
July, 2010-Sep.2010
Software Test Engineer
Contract Job
Roles and Responsibilities:
. Analyze, evaluate, and review requirements for new workflow
application and modifications to existing applications for appropriate
functionality and testability.
. Responsible for writing test plans, creating test cases, executing
test cases ensuring that the developed software performs as detailed
by the business requirements and UAT Scripts for user help.
. Tested application security features, including session expiry, book
marking, passwords and compatibility across multiple browser types and
encryption levels.
. Create new Change Requests (CRs) for discovered bugs and track their
status until they deploy into production.
. Participated in walkthroughs and technical reviews to report testing
status and Interface with developers to resolve technical issues and
investigate the bugs in the application.
. Perform data testing to filter the qualified data in an SQL based
database and worked with developers to verify the data fixes for
production support.
. Performed Interface testing to verify that all interactions between
servers (application, database, and web) are executed properly, errors
are handled as expected and proper error messages are displayed back
to the user.
Environment: Windows XP Professional, SQL, SQL Server 2005, MS Access,
Team Track.
Walgreens
Dec., 2008-Jan 2010
Junior DBA
Roles & Responsibilities:
. Performed SQL Server Database Administration duties including
maintaining database security and integrity at all times over multiple
recovery points
. Maintained multiple production and test system databases, including
performance monitoring, tuning, and 24 / 7 support
. Interacted with applications group, technical support, and operations
to maintain existing applications
. Define and maintain databases, views, tables, attributes and stored
procedures.
. Maintained SQL Server production and test system databases, and
implemented changes for each new software release using SQL and C++
code.
. Extensively involved in discussions and meetings with Project Manager,
Team Manager and other team members regarding the test procedures,
test result analysis.
Environment: Window 2003,SQL Server 2005, SSIS,SQL Server
management Studio.C++, Java, XML,,Web services.
Lipper Analytical Services Inc.
July, 2008-Sep, 2008
Data Analyst / Backend Tester
Contract Job
Roles & Responsibilities:
. Extract requirements from technical specifications, functional
requirements and prepare test plan based on test requirements which
includes all test items and test cases.
. Working on Stored Procedures, Stored Functions, Database Triggers and
Packages using PL/SQL Developer.
. Performed Functionality, Backend testing, Unit testing, Integration &
System Testing.
. Identified, documented and tracked all system application defects,
providing complete details and attached documents relevant to defect
resolution.
. Performed GUI, performance testing, stress testing, and data
validation testing of the application.
. Developed SQL scripts for data retrieval and manipulation.
. Seek out, identify, and replicate bugs in functionality, interface,
and design, which are communicated via Bugzilla, a defect tracking
tool.
Environment: Windows XP, UNIX, Visual Basic, Oracle 10g, PL/SQL
developer, Oracle Enterprise Manager and Bugzilla.
Sun Microsystems.
April, 2008-June, 2008
Knowledge Base Administrator
Contract Job
Roles & Responsibilities:
. Perform Administrative duties for data cleanup for Oracle ERP
applications.
. Proofing, capturing data from internal sources and taking backups
after updating data files and creating reports.
. Generate and maintain SQL scripts for database testing.
. Tested the HTML pages for the business rules of the application.
. Reporting on adoption, compliance and performance.
. Editing of Sun system handbook documents and IBIS Technical
Instructions to bring content into alignment with the quality
standards and required structure.
. Assisting Sun On-line Support and eSupport Readiness projects.
Environment: HP -Solaris 2.8, Visual Basic, Oracle 10g, SQL, XML,
HTML, TOAD, TSL
Scripts.
SeniorMed
July, 2002-Feb, 2008
Network / System Administrator
Roles & Responsibilities:
. Configured, Installed and supported multiple Window operating systems
(2000/XP), LINUX, Servers, MS Exchange, Active Directory, Domain and
Terminal Services.
. Troubleshooting with hardware and Networking (TCP/ IP/ LAN / WAN, VPN/
MS Office.
. Install and maintain computer peripherals, routers including firewall
security.
. Work with QS1 Database Software, Prime care workflow and Echo
Inventory Software.
. Maintenance and monitoring of various databases, application and
server activities.
. Set up multiple users, group acconts, roles and privileges profiles to
control access over databases and implemented and administered network
printing functions.
. Proactively monitor database performance and checking warnings and
alerts and take appropriate actions.
. Assist in taking regular database backup using Veritas and setting
recovery procedures.
Environment: Windows XP Professional, SQL, SQL Server 2005, MS
Office, Active
Directory.
Educational Qualifications:
. Bachelors in Computer Science from M D University, India
. Diploma in personal Computer Hardware and maintenance.
. Certification of Oracle 10g Database Administration (OCA) Oracle
University.
References:
Available upon Request
Contact this candidate